(I am using CR 9) I am trying to calculate an average amount of a currency field in my report and I need a formula to get the prior months amount. The problem I am having is the report groups on an "as of" date field and is then formatted to multiple columns to show the amounts over the course of 4 months. The date field is for month end and will change when a new month begins. The average also has to show for all 4 months. If anyone has an idea for a formula, please let me know...

I hope this makes sense!
Thanks.