I faced a calculation problems in SAC, our problem is the following:
- gross value KPI show ‘-‘ every dimension member. The gross value calculate from gross price x unit, and I set details calculation, the aggregation type is sum.
- if I switch off the Details calculations the KPI is calculating on leaf members, but show 0 on consolidated member
- The main problem is, the gross price KPI isn’t additive key figure, so I set the aggregation type None. If I modify to SUM, the gross value calculating every dimension member, but the value isn’t correct on consolidated member.
- Without currency the calculation works fine.
Could anybody help, what I have to set up or off, to calculate as desired?
Details calculation of
Details calculation on