I am trying to make an outlier flag that flags values 50% above of 50% below the budgeted, or daily goal mount. I made two threshold calculations(dailygoal / 2) & (dailygoal * 1.5). I keep getting an error message, but I am not sure what I am doing wrong.
Any suggestions?
Thanks, and my sql command is attached below.
CASE WHEN
Donors
BETWEEN
Lower Budget Threshold
AND Upper Budget Threshold
THEN 'Normal'
ELSE
'Outlier'
END