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

harpreet1008

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

 

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

 

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

harpreet1008

It works. Thank you 🙂