Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try wrapping it around with Sum(Aggr(, AllYourDimensions))
Sum(Aggr(((Sum([Amount in doc. curr.])* avg({<PYTD_Flag={1}>}[Actual Rate]))*-1)/1000, Dimensions))
Try wrapping it around with Sum(Aggr(, AllYourDimensions))
Sum(Aggr(((Sum([Amount in doc. curr.])* avg({<PYTD_Flag={1}>}[Actual Rate]))*-1)/1000, Dimensions))
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