topic XIRR function mismatch in App Development https://community.qlik.com/t5/App-Development/XIRR-function-mismatch/m-p/1248978#M25105 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Does anyone have experience with XIRR () function results not matching Excel or any other tool's XIRR() function result.</P><P></P><P>I Have a simple app here where my result is off by a few %.</P><P></P><P>I should be getting similar results but excel gives different XIRR</P><P></P><P>Of course for excel I have to have unique dates but that's the only difference whereby I summarize at date level</P></BODY></HTML> Wed, 08 Mar 2017 08:14:42 GMT avastani 2017-03-08T08:14:42Z XIRR function mismatch https://community.qlik.com/t5/App-Development/XIRR-function-mismatch/m-p/1248978#M25105 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Does anyone have experience with XIRR () function results not matching Excel or any other tool's XIRR() function result.</P><P></P><P>I Have a simple app here where my result is off by a few %.</P><P></P><P>I should be getting similar results but excel gives different XIRR</P><P></P><P>Of course for excel I have to have unique dates but that's the only difference whereby I summarize at date level</P></BODY></HTML> Wed, 08 Mar 2017 08:14:42 GMT https://community.qlik.com/t5/App-Development/XIRR-function-mismatch/m-p/1248978#M25105 avastani 2017-03-08T08:14:42Z Re: XIRR function mismatch https://community.qlik.com/t5/App-Development/XIRR-function-mismatch/m-p/1828884#M68310 <P>I have been having the same problem. Has anyone found a solution to this yet?</P> Mon, 16 Aug 2021 17:23:00 GMT https://community.qlik.com/t5/App-Development/XIRR-function-mismatch/m-p/1828884#M68310 robynbitner 2021-08-16T17:23:00Z