Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.