How to model annual inflation in Anaplan?

Hi Anaplan Modeling Experts,

 

I found it is not that straightforward to play with timeseries data in Anaplan, when the calculation logic for a specific item is referring to the values of itself from the previous period.

 

In this example, I am trying to model the annual inflation rates.

 

In Excel, it is quite easy, just type the formula once and drag and drop for the rest of the cells in column D (see attachement or below):

 

Forum 1.png

 

What would be the recommended option to model this in Anaplan?

 

Kind regards,

 

Ding

 

Best Answer

  • @DingZ 

    @Noemi.andres suggestion is a good one.

    Additionally, you can create what's called a system module, a separate module that only contains the annual inflation rates. 

    Then you can just look it up from you calculation module.

    Check out DISCO method.

Answers