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