+ Start a Discussion

Calculate Rolling Total

I have a report to track the bookings each week.  The summarized Amount gives me the total for each week.  What I am actually looking for is to calculate how much we have booked so far at the end of each week, or the rolling total.

Week1 = $WK1_Amount
Week2 = Week1 + $WK2_Amount
Week3 = Week1 + Week2 + $WK3_Amount
... and so on


It believe SFDC needs to develop a new summary formula for this, but I'd like to ask experts out there if you know how to calculate this on the report builder?


Please like this idea on the Idea Exchange: https://success.salesforce.com/ideaView?id=08730000000knonAAA