topic Re: Summation to the n-th period in App Development https://community.qlik.com/t5/App-Development/Summation-to-the-n-th-period/m-p/1056206#M16807 <HTML><HEAD></HEAD><BODY><P>sum(valueloop(1, n)*CF/pow(1+i),valueloop(1,n)) </P></BODY></HTML> Sat, 23 Jan 2016 14:03:15 GMT Gysbert_Wassenaar 2016-01-23T14:03:15Z Summation to the n-th period https://community.qlik.com/t5/App-Development/Summation-to-the-n-th-period/m-p/1056205#M16806 <HTML><HEAD></HEAD><BODY><P>Hey all, I'm trying to calculate a formula that uses a summation and I don't know the best way to tackle this. I've played around with loops in the load script and using the aggr() function but can't seem to get it right.</P><P></P><P>I have three variables that I already have calculated: cash flow (CF), interest rate ( i ) and number of periods (n).</P><P></P><P>The formula mathematically looks like:</P><P><SPAN style="color: #222222; font-family: arial, sans-serif; font-size: 16px;">Σ ( t * CF) / ((1 + i ) ^ t</SPAN> )</P><P>from t=1 to n</P><P></P><P>If anyone has dealt with this kind of formula before in Qlik I'd greatly appreciate some help. Thank you!</P></BODY></HTML> Fri, 22 Jan 2016 14:12:19 GMT https://community.qlik.com/t5/App-Development/Summation-to-the-n-th-period/m-p/1056205#M16806 tsglenn22 2016-01-22T14:12:19Z Re: Summation to the n-th period https://community.qlik.com/t5/App-Development/Summation-to-the-n-th-period/m-p/1056206#M16807 <HTML><HEAD></HEAD><BODY><P>sum(valueloop(1, n)*CF/pow(1+i),valueloop(1,n)) </P></BODY></HTML> Sat, 23 Jan 2016 14:03:15 GMT https://community.qlik.com/t5/App-Development/Summation-to-the-n-th-period/m-p/1056206#M16807 Gysbert_Wassenaar 2016-01-23T14:03:15Z Re: Summation to the n-th period https://community.qlik.com/t5/App-Development/Summation-to-the-n-th-period/m-p/1056207#M16808 <HTML><HEAD></HEAD><BODY><P>You may also want to have a look in the HELP at the <STRONG style="font-size: 10pt; line-height: 1.5em;">Financial Aggregation Functions in Charts,</STRONG></P><P>namely npv() and xnpv() might be of interest.</P></BODY></HTML> Sat, 23 Jan 2016 14:16:02 GMT https://community.qlik.com/t5/App-Development/Summation-to-the-n-th-period/m-p/1056207#M16808 swuehl 2016-01-23T14:16:02Z