Calculation Help

[fcecconi]

I am working in Sense and my calculation totals in my pivot table are wrong.  However when I select the currency code, then the totals are showing the correct value.

Dimensions	Measures
Aerospace	161
EUR	25
GBP	10
JPY	30
USD	15

The calculation for the measure is (it is a master measure):

((Sum([Amount in doc. curr.])* avg({<PYTD_Flag={1}>}[Actual Rate]))*-1)/1000

The individuals values are correct, but the sub total (for Aerospace) is not.

thanks

Frank

[sunny_talwar · Accepted solution]

Try wrapping it around with Sum(Aggr(, AllYourDimensions))

Sum(Aggr(((Sum([Amount in doc. curr.])* avg({<PYTD_Flag={1}>}[Actual Rate]))*-1)/1000, Dimensions))

[fcecconi]

Sunny

I changed to calculation to:

Sum(Aggr(((Sum([Amount in doc. curr.])*

Avg({<CYTD_Flag={1}>}[Actual Rate]))*-1)/1000,[Market Description],[Currency Code]))

And works as expected.  thanks