IRR & NPV Calculations with Initial/Start Date

Hi All,

I have tried a workaround for IRR, NPV calculations with initial Date i.e. similar to excel in Anaplan. It worked for me and Hoping that it will be helpful for others too

I hope below Screenshots are in-detail to understand the logic.

SS02 IRR.PNG

SS03 NPV.PNG

SS01_99038.PNG

SS02_IRR_99038.PNG

SS03_NPV_99038.PNG

Accepted answers

All comments

JaredDolich

@Vinaygvk7

Yes. Thanks for sharing this. I added this to my own list of best practices. I had a feeling there was a good solution.

Nicely handled!

Vinaygvk7

@JaredDolich Thanks!

Quick Links

Can you help?

Unanswered questions

Hi Team , I am unable to login to the Anaplan portal using my credential.
Can someone help me i am unable to login anaplan portal using my credentials
Finding History for List Item Creation and changes
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
Action fails via cloudworks but works manually
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made to…