Click to See Complete Forum and Search --> : How to Sum last three groups


abstract
May 2nd, 2006, 09:47 PM
I have a report that has a Payment field on the details line. It is then grouped by Month. The group footer contains a sum of the payments for that month.

How do I create a formula that displays the sum for the last three months?


Mon Sum 3monthSum
Jan 20.00 20.00 //(Jan)
Feb 10.00 30.00 //(Jan - Feb)
Mar 40.00 70.00 //(Jan - Mar)
Apr 30.00 80.00 //(Feb - Apr)
May 15.00 85.00 //(Mar - May)


Thanks,

Madhi
May 27th, 2006, 09:21 AM
Do you want to find summation of sum of each month?
Make use of Running total feature