topic Calculating IRR from Cash Flow values in QlikView https://community.qlik.com/t5/QlikView/Calculating-IRR-from-Cash-Flow-values/m-p/474112#M1148839 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can anyone please help me calculating IRR(Internal Rate of Return) from a range of Cash Flow values in a span of 10 years.</P><P></P><P>Thank you in advance!</P><P></P><P>Sunil</P></BODY></HTML> Sat, 15 Jun 2013 09:40:42 GMT 2013-06-15T09:40:42Z Calculating IRR from Cash Flow values https://community.qlik.com/t5/QlikView/Calculating-IRR-from-Cash-Flow-values/m-p/474112#M1148839 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can anyone please help me calculating IRR(Internal Rate of Return) from a range of Cash Flow values in a span of 10 years.</P><P></P><P>Thank you in advance!</P><P></P><P>Sunil</P></BODY></HTML> Sat, 15 Jun 2013 09:40:42 GMT https://community.qlik.com/t5/QlikView/Calculating-IRR-from-Cash-Flow-values/m-p/474112#M1148839 2013-06-15T09:40:42Z Re: Calculating IRR from Cash Flow values https://community.qlik.com/t5/QlikView/Calculating-IRR-from-Cash-Flow-values/m-p/474113#M1148840 <HTML><HEAD></HEAD><BODY><P>Thanks, I got it:</P><P></P><P>=Round((rangeirr($(irxary)))*100)</P><P></P><P>where irxary is the cashflow value string.</P></BODY></HTML> Sat, 15 Jun 2013 11:45:57 GMT https://community.qlik.com/t5/QlikView/Calculating-IRR-from-Cash-Flow-values/m-p/474113#M1148840 2013-06-15T11:45:57Z