Formula

AmruthaB
Contributor

Formula

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 

2 REPLIES 2
prabhu
Community Boss

Re: Formula

Hi @AmruthaB ,

 

I tried ur scenario, it works well for me.  

 

 

11.PNG

 

 

Thanks,

 

Sorna Raja Prabhu
AmruthaB
Contributor

Re: Formula

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.