IRR - returning NaN

[naveed.bakshi]

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

[naveed.bakshi]

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

David

[naveed.bakshi]

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