Aggr in Calculated Dimension v Expression

[johngouws]

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

[Anonymous · Accepted solution]

Try as your calculated Dimension:

=AGGR(SUM(Aggr(

If(sum((Qty * Value) + Debits + Credits) > 0,  Sum(OpeningFloat) ),

Group, Property ,Name)),Group)

[johngouws]

Hello Michael.

Thank you, that works perfectly.

John