Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a calculation that needs to be done aggregating on one key dimension.
This seems to work fine, til I want to display the calculation on another dimension.
=if
(
sum(aggr(Sum (Qty1), %Key))=0
and
sum(aggr(sum(Qty2), %Key))>sum(aggr(sum(Qty3, %Key))
,sum(aggr(Sum (Qty4), %Key))
,0
)
How can I display it on Group dim? I tried to add in the aggr expression but didn't work.
So in the table I would like it to say 13 as a total.
Also I would like to display this in a graph with Group as dim, without the key.
Attached example.
Thanks.
HI,
Here is the expression.,
=sum(aggr(if
(
sum(aggr(Sum (Qty1), %Key))=0
and
sum(aggr(sum(Qty2), %Key))>sum(aggr(sum(Qty3), %Key))
,sum(aggr(Sum (Qty4), %Key))
,0
),%Key))
Regards,
Kaushik Solanki
HI,
Here is the expression.,
=sum(aggr(if
(
sum(aggr(Sum (Qty1), %Key))=0
and
sum(aggr(sum(Qty2), %Key))>sum(aggr(sum(Qty3), %Key))
,sum(aggr(Sum (Qty4), %Key))
,0
),%Key))
Regards,
Kaushik Solanki
Thanks!
Works perfect