Skip to Content
0
Aug 08, 2023 at 01:12 PM

Calculation between 2 versions

71 Views Last edit Aug 10, 2023 at 11:48 AM 5 rev

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)).

image.png image.png

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

image.png

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

Attachments

image.png (29.5 kB)
image.png (14.8 kB)
image.png (59.8 kB)