Long time listener, first time caller.

I have a cross-tab report that has field I would like to conditionally format. 
I would like to compare an individuals loss ratio to the overall company average +/- 5 points.

I have put together the following formula...

if Sum ({AGENT.LossRatio}, {AGENT.AgencyNo}) >= Sum ({AGENT.Company_Average}, {AGENT.AgencyNo}) + 5 then crRed else
if Sum ({AGENT.LossRatio}, {AGENT.AgencyNo}) <= Sum ({AGENT.Company_Average}, {AGENT.AgencyNo}) - 5 then crGreen else crBlack

The formula turns all the amounts either red or greed based on if they are higher or lower than the company average, it DOES NOT recognize the +/- 5 points.

What am I missing?

Nope, no syntax errors.  I have tried it with the parenthesis since and it didn't change the results. 

Upon closer inspection it looks like the results I am seeing on the report are wholesale.  The values for each cross-tab are getting either a red or a green value based on one comparison instead of a evaluation for each record.  The report  has 4 groups

AgencyName
  DataType
     AgencyNo
         LOB

The cross tab is in the AgencyNo footer, the data is already summarized at the detail level.