cancel
Showing results for 
Search instead for 
Did you mean: 

Calculated value show ’-’ or not summarized on aggregated dimension member

former_member510310
Discoverer
0 Kudos
857

Hi All,

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?

KPI

Details calculation of

Details calculation on

Accepted Solutions (1)

Accepted Solutions (1)

JohnL
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Norbert,

Please do not use the "Calculate on Details" calculation feature as it will be deprecated / not supported in the very near future.

See the resolution in article 2527989 - Details cannot be calculated on IF formula in SAP Analytics Cloud (BOC)

Use the exception aggregation 'SUM' with all required dimensions as exception aggregation dimensions. In your case you should add Country and Time as exception aggregation dimensions.

Also please note the warning when you are looking at the local currency calculation:
A value is only shown if all child nodes have the same unit or currency.

See the following article on Exception Aggregation in SAP Analytics Cloud: Applying Aggregation in SAP Analytics Cloud

JohnL
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Norbert,

Also see this great overview on Price * Volume Formulas ( calculations ) in our online help guide:

https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/78d550c8cb154c25b8e73810fabc...

Answers (0)