topic Re: Calculate Compound Interest. in QlikView https://community.qlik.com/t5/QlikView/Calculate-Compound-Interest/m-p/1038285#M349765 <HTML><HEAD></HEAD><BODY><P>=2000*pow(1+0.08/365, 5*365)</P><P>With formatting:</P><P>=Num(2000*pow(1+0.08/365, 5*365),'##.00')</P></BODY></HTML> Fri, 26 Feb 2016 12:27:18 GMT tresB 2016-02-26T12:27:18Z Calculate Compound Interest. https://community.qlik.com/t5/QlikView/Calculate-Compound-Interest/m-p/1038283#M349763 <HTML><HEAD></HEAD><BODY><P>Hi All, </P><P></P><P>I have a working example of calculating interest in excel and would like to get to the same answer in QlikView. </P><P></P><P>EXCEL EXAMPLE:</P><P>Compound Interest Calculator</P><P>Initial investment&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 2000</P><P>Annual Interest Rate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 8%</P><P>No. of compound periods&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 365</P><P>Years&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 5</P><P> Balance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 2 983.52 </P><P></P><P>"Balance" is derived from : "=2000 * (1 + 0.08 /365) ^ (5 * 365)". </P><P></P><P>In QlikView I am trying&nbsp;&nbsp; "pow(2000 * (0.1 + (0.08 / 365)), (5 / 365))"&nbsp;&nbsp;&nbsp; but not getting the correct answer. I am obviously doing something wrong. The attached qvw shows example. </P><P></P><P>Thank you very much. </P></BODY></HTML> Fri, 26 Feb 2016 12:22:52 GMT https://community.qlik.com/t5/QlikView/Calculate-Compound-Interest/m-p/1038283#M349763 johngouws 2016-02-26T12:22:52Z Re: Calculate Compound Interest. https://community.qlik.com/t5/QlikView/Calculate-Compound-Interest/m-p/1038284#M349764 <HTML><HEAD></HEAD><BODY><P>exp is seem ok.&nbsp; 1.07531...</P><P></P><P>the value it is givng? wrng/</P></BODY></HTML> Fri, 26 Feb 2016 12:24:48 GMT https://community.qlik.com/t5/QlikView/Calculate-Compound-Interest/m-p/1038284#M349764 Chanty4u 2016-02-26T12:24:48Z Re: Calculate Compound Interest. https://community.qlik.com/t5/QlikView/Calculate-Compound-Interest/m-p/1038285#M349765 <HTML><HEAD></HEAD><BODY><P>=2000*pow(1+0.08/365, 5*365)</P><P>With formatting:</P><P>=Num(2000*pow(1+0.08/365, 5*365),'##.00')</P></BODY></HTML> Fri, 26 Feb 2016 12:27:18 GMT https://community.qlik.com/t5/QlikView/Calculate-Compound-Interest/m-p/1038285#M349765 tresB 2016-02-26T12:27:18Z Re: Calculate Compound Interest. https://community.qlik.com/t5/QlikView/Calculate-Compound-Interest/m-p/1038286#M349766 <HTML><HEAD></HEAD><BODY><P>Thank you. </P><P></P><P>I see the places I went wrong. Appreciate it. </P><P></P><P>John</P></BODY></HTML> Fri, 26 Feb 2016 13:05:11 GMT https://community.qlik.com/t5/QlikView/Calculate-Compound-Interest/m-p/1038286#M349766 johngouws 2016-02-26T13:05:11Z