en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Jens Henrik Rauff Hansen  
#1 Posted : Tuesday, December 18, 2012 9:52:29 AM(UTC)
Jens Henrik Rauff Hansen
Rank: Advanced Member

Groups: extranet\Customer
Joined: 11/16/2012(UTC)
Posts: 24

Hi Targit

I am trying to reference directly to at subtotal, but i am only able to get sum of all children. I need the subtotal because i use a destinct count, see the picture beneath

UserPostedImage
Uploaded with ImageShack.us

The current formula used:
sum(d-1, all(s), m1, 0)

Edited by user Tuesday, December 18, 2012 10:31:24 AM(UTC)  | Reason: Not specified

David L. Bojsen  
#2 Posted : Tuesday, December 18, 2012 9:55:34 AM(UTC)
David L. Bojsen
Rank: Member

Groups: extranet\Customer
Joined: 4/5/2011(UTC)
Posts: 6

jhrh@novax.dk wrote:
Hi Targit

I am trying to reference directly to at subtotal, but i am only able to get sum of all children. I need the subtotal because i use a destinct count, see the picture beneath

[img][/img]

The current formula used:
sum(d-1, all(s), m1, 0)



Hi Jens Henrik

Could you try with the attached image again?

/ David - TELMORE
Jens Henrik Rauff Hansen  
#3 Posted : Tuesday, December 18, 2012 11:38:47 AM(UTC)
Jens Henrik Rauff Hansen
Rank: Advanced Member

Groups: extranet\Customer
Joined: 11/16/2012(UTC)
Posts: 24

The picture should be available now
Daniel  
#4 Posted : Tuesday, December 18, 2012 1:13:48 PM(UTC)
Daniel
Rank: Advanced Member

Groups: extranet\Customer
Joined: 11/29/2012(UTC)
Posts: 18

Hi Jens Henrik,

I just saw this post and I think I run into something similar some time ago. Try this calculation and let me know how it works!

sum(d-1, 0(l1), m1)

Dani
Jens Henrik Rauff Hansen  
#5 Posted : Wednesday, December 19, 2012 12:45:11 PM(UTC)
Jens Henrik Rauff Hansen
Rank: Advanced Member

Groups: extranet\Customer
Joined: 11/16/2012(UTC)
Posts: 24

Hi Dani

This only gives me the folowiing reference:

UserPostedImage
Daniel  
#6 Posted : Wednesday, December 19, 2012 5:51:05 PM(UTC)
Daniel
Rank: Advanced Member

Groups: extranet\Customer
Joined: 11/29/2012(UTC)
Posts: 18

I see, uh.... It is tough to find the right one without the data to reproduce your particular case. Anyway, try this one and let's see if we have better luck! ;)

sum(d-1, 0(r(0,1)), m1)
Jens Henrik Rauff Hansen  
#7 Posted : Thursday, December 20, 2012 12:41:59 PM(UTC)
Jens Henrik Rauff Hansen
Rank: Advanced Member

Groups: extranet\Customer
Joined: 11/16/2012(UTC)
Posts: 24

Thank you that worked perfectly: my final formula was:

if (sum(d-1, 0, m1, 0) / sum(d-1, 0(r(0,1)), m1) * 100) > 100
then 100
else (sum(d-1, 0, m1, 0) / sum(d-1, 0(r(0,1)), m1) * 100)

The if-else was to eliminate at strange number in the main total
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error