https://community.qlik.com/t5/QlikView/IRR-fuction/m-p/1538639#M600101 <DIV class="topic-subject-wrapper"><DIV class="lia-message-subject lia-component-message-view-widget-subject"><DIV class="MessageSubject">&nbsp;</DIV></DIV></DIV><DIV class="lia-message-body lia-component-body-signature-highlight-escalation"><DIV class="lia-message-body-content"><P><FONT size="2">Hi Friends,</FONT></P><P><FONT size="2">I need your help please, I struggle with the IRR function, here is my&nbsp; sql server table:</FONT></P><P><FONT size="2">I want to calculate the the internal rate&nbsp; (IRR) for each Projet. I ve used&nbsp;=RangeIRR($(vinvet),$(repeat(vpayment &amp;',',$(vNumber-of-payment)))) but is not working. I need to get those variable from SQLServer and calculate the IRR. thank you very much</FONT></P><TABLE><TBODY><TR><TD>projet</TD><TD>invest</TD><TD>payment</TD><TD>Number-of- payment</TD></TR><TR><TD>A</TD><TD>-5000</TD><TD>200</TD><TD>12</TD></TR><TR><TD>B</TD><TD>-3000</TD><TD>600</TD><TD>25</TD></TR><TR><TD>C</TD><TD>-7000</TD><TD>500</TD><TD>36</TD></TR></TBODY></TABLE></DIV></DIV> Fri, 01 Feb 2019 20:35:00 GMT Jamal 2019-02-01T20:35:00Z https://community.qlik.com/t5/QlikView/IRR-fuction/m-p/1538639#M600101 <DIV class="topic-subject-wrapper"><DIV class="lia-message-subject lia-component-message-view-widget-subject"><DIV class="MessageSubject">&nbsp;</DIV></DIV></DIV><DIV class="lia-message-body lia-component-body-signature-highlight-escalation"><DIV class="lia-message-body-content"><P><FONT size="2">Hi Friends,</FONT></P><P><FONT size="2">I need your help please, I struggle with the IRR function, here is my&nbsp; sql server table:</FONT></P><P><FONT size="2">I want to calculate the the internal rate&nbsp; (IRR) for each Projet. I ve used&nbsp;=RangeIRR($(vinvet),$(repeat(vpayment &amp;',',$(vNumber-of-payment)))) but is not working. I need to get those variable from SQLServer and calculate the IRR. thank you very much</FONT></P><TABLE><TBODY><TR><TD>projet</TD><TD>invest</TD><TD>payment</TD><TD>Number-of- payment</TD></TR><TR><TD>A</TD><TD>-5000</TD><TD>200</TD><TD>12</TD></TR><TR><TD>B</TD><TD>-3000</TD><TD>600</TD><TD>25</TD></TR><TR><TD>C</TD><TD>-7000</TD><TD>500</TD><TD>36</TD></TR></TBODY></TABLE></DIV></DIV> Fri, 01 Feb 2019 20:35:00 GMT https://community.qlik.com/t5/QlikView/IRR-fuction/m-p/1538639#M600101 Jamal 2019-02-01T20:35:00Z