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.
Tagged:
0
Best Answer
-
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.htmlAnd 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
3
Answers
-
Thank you Taichi, this really helped.
Regards,
Madhu
1