Manual (Mock) Cross Tab Formatting Help

[grendel81]

I am trying to create a cross tab based on 13 months of data. There are several sections, with several measurements per section. Each value for each month must be compared to a target value for that month. I have a formula that does the comparasin, and writes the results to a variable, as well as displays the value. The variable is used to conditionally format the background of the value.

I have the report built as follows:
GH1: Section
GH2: Measurement Name (Hidden)
D: @conditional (as shown below)
GF2: Summary of the @conditional (sum)
GF1: (Hidden)

@conditional
//note that this is for the current month -3
if date({Command.YEAR},{Command.MONTH},1) = dateadd("m",-3,date({?Year},{?Month},1)) then
if not isnull(Actual_Value) then
if {Actual_Value} > {Target_Value} then
(month3:=1;
{Actual_Value})
else
(month3:=2;
{Actual_Value})
else
month3:=1;

Then in GF2, I have formatted the background to display colours based on the value of month3. The problem I am having is that month3 doesn't seem to be calculated in the GF2 if I hide or suppress the Details section.

Any Ideas? It is a requirement that I be able to conditionally colour the background based on the actual_value and Target_value for the month in question. Those values will change with each month.

Thanks in advance for any assistance.

 

[grendel81]

I should have mentioned, I am using CR 9 Adv.