General information
Title:
Prior month formatted to multple columns
(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.
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only