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