Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Resolving partial sums - For loop?

Hi all,

I have an interesting issue I am about to take on. I need to calculate a partial sum.

Y = T - aΣ x/(1+b)^i


Where the partial sum (Σ) is from i=1 to n and varies for each record between 1 and 25. Basically all of the terms of the equation are known and are in a single row of a table except for y. Each record has this single row of known terms.


I would like to add a column to the table for y using the data from that single row into this equation.


How do I get this partial sum to resolve? Is a For loop in the script my best option?

Many thanks,

Mike

0 Replies