Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning,
I am having an issue achieving the required result in a Calculated Dimension.
In the attached qvw there are 3 objects on the left, straight tables, using aggr in the expression. Regardless of which Dimensions are used, the result is correct and balances to the sample report.
However, what I am trying to achieve is get the same result, as a single number, at a "Group" level, in a calculated dimension, in the straight table on the right.
I appreciate any and all suggestions in this regard.
Thank you in advance - John
Try as your calculated Dimension:
=AGGR(SUM(Aggr(
If(sum((Qty * Value) + Debits + Credits) > 0, Sum(OpeningFloat) ),
Group, Property ,Name)),Group)
Try as your calculated Dimension:
=AGGR(SUM(Aggr(
If(sum((Qty * Value) + Debits + Credits) > 0, Sum(OpeningFloat) ),
Group, Property ,Name)),Group)
Hello Michael.
Thank you, that works perfectly.
John