For some reason this CASE statement will not validate. I have all the required parts. `PayTotal` and `PayTargetWeek` are both number values and I want this field to return a character string.
case when (sum(`PayTotal`) / `PayTargetWeek`) <= -.05 then 'Under Target'
when (sum(`PayTotal`) / `PayTargetWeek`) >= -.049 and <= .05 then 'On Target'
when (sum(`PayTotal`) / `PayTargetWeek`) >= .051 then 'Above Target'
else 'Not Sure'
end