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

 

Best Answer

  • alexpavel
    Answer ✓

    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

     

Answers