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??
You can use CUMULATE for this. https://help.anaplan.com/1173a903-81bb-4838-a4d0-1c9f9c739aa3-CUMULATE
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
It works. Thank you 🙂0