I created a report from a cross tab query and want to conditional format a field based on another fields data.
The report has the field [KO CL CD] which can be "K" or "O" and [%Exp] which is a percentage. The "K" indicates that the Job Order is closed with "O" indicating that the Job Order is open. I am trying to format the field [%Exp] yellow if the percentage is between 80% and 90% and the field [KO CL CD] ="O". I tried the below expression in conditional formatting and had no luck.
([%Exp] between 0.8 and 0.9) and [KO CL CD] ="O")
Appreciate any help
Regards
Hikerdood