Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
laurafinn
Contributor III
Contributor III

Cumulative SUM in expression

Hi all,

I have the below formula that works to calculate:  The Sum of the weekly budget ([Budget amount]/nbWeeks2)) where the budget line is Quality of life ({<[Sheet1.Budget Re-categorised]={'Quality of Life'}>}) where the week in the budget file is equal to the current week - 1.

Sum({<[Sheet1.Budget Re-categorised]={'Quality of Life'}>} IF([Sheet1.Week] = [Current week]-1, [Budget amount]/nbWeeks2))

HOWEVER,

I need the cumulative sum of the weekly budget up to the current week -1, how do I amend the above formula to give me the cumulative sum rather than just the value of the budget for week-1?

From other posts I've read it looks like a need a Rangesum but I'm struggling with the syntax.

Labels (1)
0 Replies