How to populate number series in every upcoming month in a line item

Hi, I have identified the starting month to start the series through boolean and time period function. However, starting from that month till end i want to populate numbers in a series on every upcoming month(eg. if starting month is march then for march i need to populate 1 in a separate line item. now for April the value of this line item should be 2, for may it should be 3 and so on. How do i achieve that??

Please Help

Accepted answers

alexpavel

in a numeric line-item named "Num Month" to have a formula like this:

IF Starting Month THEN 1 ELSE IF PREVIOUS(Num Month) <> 0 THEN PREVIOUS(Num Month) + 1 ELSE 0

The trick is that you can use the same line-item when you use Previous function.

Hope it helps

Alex

All comments

KirillKuznetsov

@harpreet1008

You can use CUMULATE for this. https://help.anaplan.com/1173a903-81bb-4838-a4d0-1c9f9c739aa3-CUMULATE

CUMULATE(1, <boolean>,TIME)

ManjunathKN

Hi @harpreet1008

you can write this formula to get your results.

Separate Line item = If Boolean and Previous(boolean) then line item + previous(Line item) else Line item

Thanks,
Manjunath

alexpavel

in a numeric line-item named "Num Month" to have a formula like this:

IF Starting Month THEN 1 ELSE IF PREVIOUS(Num Month) <> 0 THEN PREVIOUS(Num Month) + 1 ELSE 0

The trick is that you can use the same line-item when you use Previous function.

Hope it helps

Alex

harpreet1008

It works. Thank you 🙂

Quick Links

Can you help?

Unanswered questions

Dimensionality - Formula Help
I have a Price module where customers are ranked based on their unit prices. I also have a Comparison module, where I want to display the names and unit prices of top-ranked customers for comparison. The model includes a Customers list. In the Comparison module, I want to write formulas to bring in the customer names and…
Can there be a duplication in Process ID's
Can there be a duplication in Process ID's
Using Polaris and Classic
Client has spoke models built in Classic and now considering building Data Hub in Polaris in order to deal with sparsity. On the surface this seem possible but likely a bad idea. Has anyone done anything similar to this? Specifically, what did you have to do to ensure that data was compatible? Any thoughts or suggestions…