Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
I need to make a complex calculation, preferably as a variable.
I have made it by using a straight table, but now I need to convert it to a single formula. The desired result is the sum of rows of column Final (see attached QV file). What I want to achieve is having the user type in a QTY (variable) and use this quantity in the calculation. But this quantity needs to be only used once in the cummulation done in column 3.
Please see attached QV, it will make the case clear.
Thank you for your help.
giakoum
I figured it out myself :
Variable1 - rangesum(above((Cummulative),1,RowNo())) - Cummulative
If I get it right you mean:
(RangeSum(Column(2)-Column(1), Above(Column(3))))+$(Variable1)
If not, I didn't get it
No this is not it. I do not want the variable to be added in every row, only the first, and the result to be added in the 2nd and so on.
And I would like to change column(1) and column(2) etc to the real expressions so that I can make one expression of it and not having it on the straight table.
I figured it out myself :
Variable1 - rangesum(above((Cummulative),1,RowNo())) - Cummulative