topic Re: Used IRR formula in a Model but it is returning NaN as result whereas when Same numbers are give in Anaplan Platform
https://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41778#M4401
<P>Hi Vamshi,</P><P> </P><P>Change the module Timescale to "Year" Format.<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Photo1.png" style="width: 819px;"><img src="https://community.anaplan.com/t5/image/serverpage/image-id/22983i5FD81CB34ABA8245/image-size/large?v=1.0&px=999" title="Photo1.png" alt="Photo1.png" /></span></P>Wed, 27 Feb 2019 08:03:02 GMTVIGNESH.M2019-02-27T08:03:02ZUsed IRR formula in a Model but it is returning NaN as result whereas when Same numbers are given as
https://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41731#M4388
<P>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<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="excel.PNG" style="width: 384px;"><img src="https://community.anaplan.com/t5/image/serverpage/image-id/22976iF48E4DB4715B81C6/image-size/large?v=1.0&px=999" title="excel.PNG" alt="excel.PNG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.PNG" style="width: 592px;"><img src="https://community.anaplan.com/t5/image/serverpage/image-id/22977i41D9C3AAE7FA2BEB/image-size/large?v=1.0&px=999" title="1.PNG" alt="1.PNG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2.PNG" style="width: 480px;"><img src="https://community.anaplan.com/t5/image/serverpage/image-id/22978i9F0C903C59197FBB/image-size/large?v=1.0&px=999" title="2.PNG" alt="2.PNG" /></span></P>Tue, 26 Feb 2019 07:35:31 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41731#M4388Vamshidhar_Reddy_P2019-02-26T07:35:31ZRe: Used IRR formula in a Model but it is returning NaN as result whereas when Same numbers are give
https://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41740#M4390
<P>Hi,</P><P> </P><P>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. </P><P> </P><P>In the IRR example here - <A href="https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/IRR.html?_ga=2.176266661.1219197203.1551085839-636186280.1545216924" target="_blank">https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/IRR.html?_ga=2.176266661.1219197203.1551085839-636186280.1545216924</A> the transactions have a top level / total whereas yours do not maybe you could try adding this. </P><P> </P><P>I hope this helps! </P><P> </P><P>Usman</P>Tue, 26 Feb 2019 10:01:10 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41740#M4390usman.zia2019-02-26T10:01:10ZRe: Used IRR formula in a Model but it is returning NaN as result whereas when Same numbers are give
https://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41744#M4392
Thanks for the reply!<BR />I did try with an estimate but like you said it did not make a difference.<BR />Have you tested the '8-1275-Mark-20/2/2019' to make sure the IRR is correct for this.<BR />Yes I tried IRR for '8-1275-Mark-20/2/2019' in excel and it gave me exact answer as anaplan.<BR />I tried with top level also but it did not change anything.Tue, 26 Feb 2019 10:20:58 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41744#M4392Vamshidhar_Reddy_P2019-02-26T10:20:58ZRe: Used IRR formula in a Model but it is returning NaN as result whereas when Same numbers are give
https://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41745#M4393
<P>Interesting! </P><P>If it is calculating the correct IRR for the others then it must be correct. </P><P>My other thoughts are that maybe the IRR calc has an upper limit to what can be calculated? </P><P>Could be worth contacting support@anaplan.com and seeing if this is a known anaplan issue? </P><P> </P><P>Thanks,</P><P> </P><P>Usman</P>Tue, 26 Feb 2019 10:27:17 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41745#M4393usman.zia2019-02-26T10:27:17ZRe: Used IRR formula in a Model but it is returning NaN as result whereas when Same numbers are give
https://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41748#M4395
<P>Hi,<BR />You've done nothing wrong here, this is not working correctly.</P><P>I've tested this and this results is unexpected, it is being raised with our development teams.<BR /><BR /></P><P>As a workaround you can use a timerange instead of the date value.<BR />Using IRR(Source.Cashflow) which gives the value 49,665.2%<BR />(you will need to give Terms a top level)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="chrome_2019-02-26_12-32-09.png" style="width: 467px;"><img src="https://community.anaplan.com/t5/image/serverpage/image-id/22980iC52B6E850D5ADDBD/image-size/large?v=1.0&px=999" title="chrome_2019-02-26_12-32-09.png" alt="chrome_2019-02-26_12-32-09.png" /></span></P>Tue, 26 Feb 2019 12:41:34 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41748#M4395MarkWarren2019-02-26T12:41:34ZRe: Used IRR formula in a Model but it is returning NaN as result whereas when Same numbers are give
https://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41749#M4396
<P>Hi <LI-USER uid="220"></LI-USER> </P><P> </P><P>Will you post here to let us know once this is issue is resolved? </P><P> </P><P>Kind Regards,</P><P> </P><P>Usman</P>Tue, 26 Feb 2019 12:55:27 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41749#M4396usman.zia2019-02-26T12:55:27ZRe: Used IRR formula in a Model but it is returning NaN as result whereas when Same numbers are give
https://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41750#M4397
<P>It should be in the Platform release notes when it gets released, best to check there on each release.<BR /><A href="https://community.anaplan.com/t5/Releases/bg-p/Platform-Releases" target="_blank">https://community.anaplan.com/t5/Releases/bg-p/Platform-Releases</A></P><P>Will try and update this persoanlly if I remember!</P>Tue, 26 Feb 2019 13:46:05 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41750#M4397MarkWarren2019-02-26T13:46:05ZRe: Used IRR formula in a Model but it is returning NaN as result whereas when Same numbers are give
https://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41753#M4398
<P>Thanks! </P><P> </P><P>I'll be sure to look out for it. </P><P> </P><P> </P>Tue, 26 Feb 2019 15:13:27 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41753#M4398usman.zia2019-02-26T15:13:27ZRe: Used IRR formula in a Model but it is returning NaN as result whereas when Same numbers are give
https://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41776#M4400
how to get the time range as only years?<BR />When I put Time range I am getting all the months in each year. That is making it cumbersome.Wed, 27 Feb 2019 07:14:18 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41776#M4400Vamshidhar_Reddy_P2019-02-27T07:14:18ZRe: Used IRR formula in a Model but it is returning NaN as result whereas when Same numbers are give
https://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41778#M4401
<P>Hi Vamshi,</P><P> </P><P>Change the module Timescale to "Year" Format.<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Photo1.png" style="width: 819px;"><img src="https://community.anaplan.com/t5/image/serverpage/image-id/22983i5FD81CB34ABA8245/image-size/large?v=1.0&px=999" title="Photo1.png" alt="Photo1.png" /></span></P>Wed, 27 Feb 2019 08:03:02 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Used-IRR-formula-in-a-Model-but-it-is-returning-NaN-as-result/m-p/41778#M4401VIGNESH.M2019-02-27T08:03:02Z