Occasional 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
Community Boss

Re: IRR - returning NaN

Hi @naveed.bakshi 

 

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

Occasional Contributor

Re: IRR - returning NaN

Hi Usman,

 

Please see below. It is over 5 years.

 

IRR Module.JPG

IRR Blue print view.JPG

 

 

Thanks

Naveed

 

 

Community Boss

Re: IRR - returning NaN

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

Occasional Contributor

Re: IRR - returning NaN

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

Contributor

Re: IRR - returning NaN

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