IRR - returning NaN

Hi,

I have a module with below dimensions.

P&L Module.PNG

I need to calculate IRR for additional planes. I have followed the suggestions and created a transaction module with the following dimensions (Schedule, Aircraft, Airlines, Time month scale, versions).

Transaction schedule Blue print view.PNG

Transaction schedule.PNG

It is not returning a valid result in below module.

Any suggestions that would overcome the issue are welcome.

Thanks

Naveed

Accepted answers

All comments

usman.zia

Hi @NB

Are you able to repost the last 2 images are the links currently appear broken.

Also what is the time range you are calculating the IRR for how many periods?

Thanks,

Usman

Hi Usman,

Please see below. It is over 5 years.

IRR Module.JPG

IRR Blue print view.JPG

Thanks

Naveed

DavidSmith

It might be worth reading through this thread from earlier this year.

It might be a bug

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41740#M4390

David

Hi David,

I did refer to the thread while building the module. And added a time dimension as suggested by Mark as a work around.

If someone is able to have a look at this, it would be much appreciated.

Thanks

Naveed

Will12

Hi Naveed,

Instead of adding the time dimension to your transaction module, you should find it works if you create a separate module with the time dimension, something like this:

Thanks

William

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…