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