IRR - returning NaN

NB
Contributor
Contributor

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

 

 

5 REPLIES 5
usman.zia
Master Anaplanner/Community Boss

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

NB
Contributor
Contributor

Hi Usman,

 

Please see below. It is over 5 years.

 

IRR Module.JPG

IRR Blue print view.JPG

 

 

Thanks

Naveed

 

 

DavidSmith
Community Boss

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-...

 

David

NB
Contributor
Contributor

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
Contributor

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:

 

clipboard_image_0.png

 

clipboard_image_1.png

 

clipboard_image_2.png

Thanks

William