topic IRR function does not match Excel in QlikView https://community.qlik.com/t5/QlikView/IRR-function-does-not-match-Excel/m-p/781097#M276716 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P>I am trying to do a simple IRR function that you feed some monthly cashflows in date order. I am comparing this to Excel and the results are quite different.</P><P>The function that I'm using is : </P><P></P><P>pow</P><P></P><P></P><P><SPAN style="color: #000000; font-size: 8pt;">((1+</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">IRR</SPAN><SPAN style="color: #000000; font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">IRR.Cashflow</SPAN><SPAN style="color: #000000; font-size: 8pt;">)),12)-1</SPAN></P><P> </P><P><SPAN style="color: #000000; font-size: 8pt;">in Qlik and</SPAN></P><P> </P><P><SPAN style="color: #000000; font-size: 8pt;">= (1+IRR(D2:D481, 0))^(12)-1</SPAN></P><P> </P><P>In Excel.</P><P>Can anyone advise why I might be getting different answers? FYI, it seems that Excel is CORRECT!</P><P></P><P>Thanks.</P><P></P></BODY></HTML> Tue, 13 Jan 2015 13:31:09 GMT juleshartley 2015-01-13T13:31:09Z IRR function does not match Excel https://community.qlik.com/t5/QlikView/IRR-function-does-not-match-Excel/m-p/781097#M276716 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P>I am trying to do a simple IRR function that you feed some monthly cashflows in date order. I am comparing this to Excel and the results are quite different.</P><P>The function that I'm using is : </P><P></P><P>pow</P><P></P><P></P><P><SPAN style="color: #000000; font-size: 8pt;">((1+</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">IRR</SPAN><SPAN style="color: #000000; font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">IRR.Cashflow</SPAN><SPAN style="color: #000000; font-size: 8pt;">)),12)-1</SPAN></P><P> </P><P><SPAN style="color: #000000; font-size: 8pt;">in Qlik and</SPAN></P><P> </P><P><SPAN style="color: #000000; font-size: 8pt;">= (1+IRR(D2:D481, 0))^(12)-1</SPAN></P><P> </P><P>In Excel.</P><P>Can anyone advise why I might be getting different answers? FYI, it seems that Excel is CORRECT!</P><P></P><P>Thanks.</P><P></P></BODY></HTML> Tue, 13 Jan 2015 13:31:09 GMT https://community.qlik.com/t5/QlikView/IRR-function-does-not-match-Excel/m-p/781097#M276716 juleshartley 2015-01-13T13:31:09Z Re: IRR function does not match Excel https://community.qlik.com/t5/QlikView/IRR-function-does-not-match-Excel/m-p/781098#M276717 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333339691162px;">I am not getting different results between excel and qlikview, could it be a rounding error?</P><P style="font-size: 13.3333339691162px;">Only time I've had issue cropping up with IRR has been when the first value hasn't been a negative</P></BODY></HTML> Tue, 13 Jan 2015 14:38:29 GMT https://community.qlik.com/t5/QlikView/IRR-function-does-not-match-Excel/m-p/781098#M276717 2015-01-13T14:38:29Z Re: IRR function does not match Excel https://community.qlik.com/t5/QlikView/IRR-function-does-not-match-Excel/m-p/781099#M276718 <HTML><HEAD></HEAD><BODY><P>Turns out that the cashflows needed to be loaded into the app in the correct order (rather than just sorted once in)... values seem to match now! Thanks everyone.</P></BODY></HTML> Tue, 13 Jan 2015 15:24:37 GMT https://community.qlik.com/t5/QlikView/IRR-function-does-not-match-Excel/m-p/781099#M276718 juleshartley 2015-01-13T15:24:37Z