 Rank: Advanced Member
Groups: Administrators
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  Uploaded with ImageShack.usThe 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
|
|
|
|
|
|
Rank: Member
Groups: Administrators
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
|
|
|
|
|
|
Rank: Advanced Member
Groups: Administrators
Joined: 11/16/2012(UTC)
Posts: 24
|
The picture should be available now
|
|
|
|
|
|
Rank: Advanced Member
Groups: Administrators
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
|
|
|
|
|
|
Rank: Advanced Member
Groups: Administrators
Joined: 11/16/2012(UTC)
Posts: 24
|
Hi Dani This only gives me the folowiing reference: 
|
|
|
|
|
|
Rank: Advanced Member
Groups: Administrators
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)
|
|
|
|
|
|
Rank: Advanced Member
Groups: Administrators
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
|
|
|
|
|
|
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.