Inverse Waterfall

Options
fabio.casalegno
fabio.casalegno Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor
in Anaplan Community

Hello Community,

 

I want to create a waterfall that goes from Actuals to Budget. However, the sign of the items is reversed in the original data (negative sign means extra spend). The calculation would be:

 

2019-04-04 17_03_35-Anaplan - Fabio - Test Model.png

Is there any way to build a waterfall like this in Anaplan, keeping the original sign of the data? I tried different ways but the waterfall only works if the summary line item is a simple sum of the other items.

 

Thank you for the help.

Tagged:

Comments

  • fabio.casalegno
    fabio.casalegno Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor
    Thank you for the reply LipChean,

    I was aware of the possobility of changing the sign, but then it is also changed in the waterfall and it can be confusing for users.Maybe there is no way to solve this at this moment.

Categories