SQL database, CR 11
I need to add and divide a couple of numbers in a group footer but can't even get the first step done.
In the report I group by year and then by month.
I use a running total to get the total charges for the month in group footer 2.
Then I tried creating this formula:
{#Charges} + Previous({#Charges})
But Crystal highlights the 2nd {#Charges} after the plus sign and says:
This field has no Previous or Next value.
Any idea how I can add 3 months charges together? (The user picks the beginning and ending date - I want to add the 3 months on a rolling basis: Jan + Feb + Mar, then Feb + Mar + Apr, etc)
Thank you.
I need to add and divide a couple of numbers in a group footer but can't even get the first step done.
In the report I group by year and then by month.
I use a running total to get the total charges for the month in group footer 2.
Then I tried creating this formula:
{#Charges} + Previous({#Charges})
But Crystal highlights the 2nd {#Charges} after the plus sign and says:
This field has no Previous or Next value.
Any idea how I can add 3 months charges together? (The user picks the beginning and ending date - I want to add the 3 months on a rolling basis: Jan + Feb + Mar, then Feb + Mar + Apr, etc)
Thank you.