Used IRR formula in a Model but it is returning NaN as result whereas when Same numbers are given as

Used IRR formula in a Model but it is returning NaN as result whereas when Same numbers are given as a input to IRR formula in Excel it is returning a numbe

Accepted answers

All comments

usman.zia

Hi,

Looking at the information you've provided it seems like that the formula is correct however you've not provided an estimate for the IRR (im not sure that this is needed or has any relevance) but you could try adding one and see if this makes any difference. The NaN is normally a result when a calculation calculates something infinite. This could be to do with the summary method. Have you tested the '8-1275-Mark-20/2/2019' to make sure the IRR is correct for this.

In the IRR example here - https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/IRR.html?_ga=2.176266661.1219197203.1551085839-636186280.1545216924 the transactions have a top level / total whereas yours do not maybe you could try adding this.

I hope this helps!

Usman

CommunityMember131103

Thanks for the reply!
I did try with an estimate but like you said it did not make a difference.
Have you tested the '8-1275-Mark-20/2/2019' to make sure the IRR is correct for this.
Yes I tried IRR for '8-1275-Mark-20/2/2019' in excel and it gave me exact answer as anaplan.
I tried with top level also but it did not change anything.

usman.zia

Interesting!

If it is calculating the correct IRR for the others then it must be correct.

My other thoughts are that maybe the IRR calc has an upper limit to what can be calculated?

Could be worth contacting support@anaplan.com and seeing if this is a known anaplan issue?

Thanks,

Usman

MarkWarren

Hi,
You've done nothing wrong here, this is not working correctly.

I've tested this and this results is unexpected, it is being raised with our development teams.

As a workaround you can use a timerange instead of the date value.
Using IRR(Source.Cashflow) which gives the value 49,665.2%
(you will need to give Terms a top level)

usman.zia

Hi @MarkWarren

Will you post here to let us know once this is issue is resolved?

Kind Regards,

Usman

MarkWarren

It should be in the Platform release notes when it gets released, best to check there on each release.
https://community.anaplan.com/t5/Releases/bg-p/Platform-Releases

Will try and update this persoanlly if I remember!

usman.zia

Thanks!

I'll be sure to look out for it.

CommunityMember131103

how to get the time range as only years?
When I put Time range I am getting all the months in each year. That is making it cumbersome.

VIGNESH.M

Hi Vamshi,

Change the module Timescale to "Year" Format.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…