Pouplating year value without Time dimension

MadhabikaM

Hi All,

 

Can you please help me in populating the attached years by formula , where I am not using Timescale in the module and my

Mapping Year (line item) format is Year. 

 

CHRT** and YR** are my two dimensions used here.

 

Amaya

Hi, @MadhabikaM 

 

It may be helpful to use cumulate function along with line items.
Please see this anapedia in detail.

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/CUMULATE.html

 

And here is an example of Year adding.

 

I hope this could help you.

 

▼See CUMULATE('Number_1', FALSE, CHRT) 

 

If you don't set the current period, you may have to choose 'initial_year' manually.

 

▼Here is the result. 

 

Regards,

Taichi

MadhabikaM

Thank you Taichi, this really helped.

 

Regards,

Madhu