Formula

AmruthaB
AmruthaB
in Modeling

HI, 

Have a module with assets and time dimension, some of the assets starts from the middle of the year. when on selection of total assets, The "No of payments" lineitem not showing sequential numbers and anaplan is not  accepting(ss for the same) the "formula" summary . Below is the formula for No of Payments = IF INPERIOD(Lease Input Module.Lease start date) THEN 1 ELSE PREVIOUS('No. of Payments' + 1) . Note - in period start is nothing but the start date of the asset.

AmruthaB_0-1615264989880.png

 

 

Any help wil be highly appreciated 

Tagged:

Answers

  • prabhu
    prabhu

    Hi @AmruthaB ,

     

    I tried ur scenario, it works well for me.  

     

     

    11.PNG

     

     

    Thanks,

     

  • AmruthaB
    AmruthaB
    Hi Formula was working for me as well, As i mentioned on the post, on the selection "total" in the Asset dimension. However i was able to get the output.

Categories