IRR - returning NaN

NB

Hi, 

 

I have a module with below dimensions.

 

 

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

 

 

 

It is not returning a valid result in below module.

 

Any suggestions that would overcome the issue are welcome.

 

Thanks

Naveed

 

 

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

NB

Hi Usman,

 

Please see below. It is over 5 years.

 

 

 

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

NB

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