Excel formula in Qlikview

[#1]

Hi,

    Can anyone help me out with this formula. Column C (factor) in the attached excel is calculated from A and B. the formula is

1+SUM(B3:B$62)/SUM(B$2:B2).

Please check and let me know if this is possible in Qlikview and how it can be achieved.

Thanks in advance.

Lax

[Gysbert_Wassenaar · Accepted solution]

Try this expression:

1+rangesum(below(total sum([Policy Count]),1,61-RowNo(TOTAL)))/ rangesum(above(total sum([Policy Count]),0,RowNo(TOTAL)))

See attached qvw.