Tim wrote
I have a cross tab report that I want to schedule to refresh monthly in DocAgent.
The problem is this; the cross tab contains total cost for the last three
fiscal
months. I need to be able
to generate the percent change of the current month to the prior month.
You can set two details like LastMonth=Month(CurrentDate()-N) and PrevMonth=Month(CurrentDate()N)
(you can use CurrentDate function corrected with N=27, that will allow you to edit this report the 27 1st days following the day of your reporting, or prompt for date of reporting)
Then set a dimension MonthNb=If (Month=LastMonth) Then 2 Else if (Month=PrevMonth) Then 1 Else 0
And you put in your global break footer a formula = (Cost Where(MonthNb=2) - Cost Where(MonthNb=1))/Cost Where(MonthNb=1)
A little heavy, but dynamic !
Christophe GROS
Listserv Archives (BOB member since 2002-06-25)