Need help with Evaluation/Comparison using font color

[joethehoe]

Hello All

I have report with 4 groups that I'm trying to color code with specific information and I've hit a road block as how to over come it. What I want to do is this. If a number in one group is higher or lower than another group then CRRED.

Below is one formula: GF2:Abandon%Connects

if average ({@D:Connects},{General Information.Time Segment}) > 0 then
average ({@D:Abandons},{General Information.Time Segment}) % average ({@D:Connects},{General Information.Time Segment})
else 0

Groups:
GF1: Date Range: 2 grps. January and Febuary
GF2: JOB Name
GF3: Day of Week
GF4: Time Segment

So what I would like to do is this: Inside the field editor of the color font,

If (@GF2:Abandon%Connects, GroupName ({General Information.Job Run Date}"January&quot > (@GF2:Abandon%Connects, GroupName ({General Information.Job Run Date}"February&quot then CRRED

Sorry I know that the above formula is not correct but its the only that I can display it so as to be understandable.

Thanks in advance
Jason.