How to sum a previous period value and current period value (multiple times)

LucaRicci

Hi all,

Have been trying to sum the values from the last week and the current week to obtain a new cumulative value; this value will be the new value to be added to the current week value.

Unfortunately, this does not seem to be so easy in Anaplan.

WEEK1

I start the first week with one value (layers-actual) and, of course, the value from the previous week is 0 but it actually comes from a LOOKUP[previous week] formula. I sum these two and I get the layers - cumulative line item.

WEEK2

I start the week with a new value which is to be added to the lookupped value I get from the first week. I sum these two and I get the new cumulative value.

So far so good.

WEEK3

Now, as usual I have the new value for the week which needs to be added to the cumulative value from the last week. However, every attempt I made fails to work due to circular reference.

My formula would be for the cumulative line item:

IF WEEK=1 OR WEEK=2

THEN layers - actual + layers - previous week

ELSE layers - actual + layers - cumulative[LOOKUP: previous period]

Where am I going wrong?

Many thanks in advance,

Luca

TristanS

@LucaRicci try this formula for the cumulative line item

'layers - actual' + previous('layers - cumulative')

This will keep accumulating though from beginning to the end of the time period. So if you need to reset at some point you will need to add a condition. E.g.

If <condition to reset> then

'layers - actual'

else

'layers - actual' + previous('layers - cumulative')