Calculation between 2 versions

[119ms]

Hi all,

I have a report where I have to show 2 different Budget versions and the comparison between them as $ and %.

The measures showing the 2 different Budget versions are made in the following way:
- the former is a restricted measure based on a calculation input control (to allow users to change the Budget version inside the measure (see the pictures below)).

- the latter is based on an IF calculation (see the picture below).

In the table in my report I have the legal entity in row, whereas in columns I have:
- the accounts (made as generic dimension)
- the 2 calculated measures (which change dynamically according to the Budget version selection filter)
- the difference as $ and % between the two calculated measures above. This calculation is made in this way: add column -> repeating -> the calculation is written in the formula bar.

The accounts can be filtered dynamically according to a story filter.

My problem is that if I have a multiple selection in the account filter, the calculation (difference between the 2 budget versions) does not work properly. It works only if I have a single selection in the account filter. I guess it happens because the type of calculation I am using is positional.

Do you have a solution to perform this calculation and make it works properly? It is mandatory to have the table structured in this way:
- LE in row
- Accounts and measures in columns.

Thank you,

Martina

[nasser_itani]

Hello 119ms, have a check on the cross calculation measure.

Have a look on this help portal:

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/154158a69a6e4dbb9695e...

Thanks.