Pouplating year value without Time dimension

Highlighted
Frequent Contributor

Pouplating year value without Time dimension

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.

 

screenshot.PNG

2 REPLIES 2
Highlighted
Certified Master Anaplanner

Re: Pouplating year value without Time dimension

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) 

blueprint001.png

 

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

 

▼Here is the result. 

Result.png

 

Regards,

Taichi

Highlighted
Frequent Contributor

Re: Pouplating year value without Time dimension

Thank you Taichi, this really helped.

 

Regards,

Madhu