Question Re: Add Calculation in Technology Q&A

Add Calculation

daianealves — Fri, 29 Sep 2023 18:53:34 GMT

In SAP Analytics Cloud, is it only possible to perform measurement calculations in the same version? Because I'm trying to do a calculation with two measurements, but they have different versions and not get the result right....

Re: Add Calculation

N1kh1l — Fri, 29 Sep 2023 19:12:12 GMT

daianealves

Could you add more details

What is the calculation you are tying

Where exactly you are trying the calculation? In story editor/ Model level calculated measure/Advanced Formulas in planning model

Br.

Nikhil

Re: Add Calculation

daianealves — Fri, 29 Sep 2023 20:02:32 GMT

It is in story, in the dimension, that has the calculated measure option.

Re: Add Calculation

N1kh1l — Mon, 02 Oct 2023 17:38:38 GMT

daianealves

daianealvesIf you have 2 measures with different versions, first you need to create 2 restricted measures with versions and then use this measures in final calculations

Restricted Measures

Final calculation: I am summing 2 measures from different version as example.

Hope this helps !!

Br.

Nikhil

Re: Add Calculation

daianealves — Mon, 02 Oct 2023 17:51:10 GMT

Thank you for your help!!

Re: Add Calculation

daianealves — Mon, 02 Oct 2023 18:01:13 GMT

I forgot to ask, but if the account type is different in the calculated measures, is the calculation still done normally? Because in my calculation, the account and the version are different...

Re: Add Calculation

N1kh1l — Mon, 02 Oct 2023 18:06:39 GMT

daianealves

When creating restricted calculation, you have the option to select the Accounts. You should put screenshots of your calculation, it will help in answering.

Br.

Nikhil

Re: Add Calculation

daianealves — Mon, 02 Oct 2023 20:13:36 GMT

Ok, thank you! 🙂