Conditional Formatting Not Working

[ETCS]

I have created a cross tab report in Crystal XI. I need to display any negative numeric value as red rather than the default of black. This is the formula I am using in the format editor for font color:

If {SigVarBalances.Variance} < 0 Then crRed Else crBlack

My problem is that, when using this formula, all of the values are Red, even when they are not less than zero. (I am also having a problem doing the same type of background formatting based on the value in my header fields but that's not critical.)

I've never had this issue in a non cross tab report. Any thoughts?

 

[lbass]

Use:

If currentfieldvalue < 0 Then
crRed Else
crBlack

-LB

 

[ETCS]

Perfect! Never heard of that one before. You are the master!

Thanks,
etcs