Inverse Waterfall

fabio.casalegno

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:

 

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.

LipChean_Soh

Hi,

 

A couple of observations:

1. Are item 1, item 2 and item 3 members of the standard version? Hopefully you're just using  'Actual' and 'Budget' as example line items, otherwise you'll be adding a lot of additional workspace through item 1, item 2 and item 3.

 

2. You're right, waterfall seems to only work with the ending line item being a summation  of it's preceding line items. As such, i created 3 additional line items shown below, which are the negative of the original 'item 1', 'item 2' and 'item 3'. Finally, Actual is a summation of Budget and the 3 new line items.

 

Thanks,

LipChean