What is the error in my beastmode?

jasonm5545

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

david_cunningham

@jasonm5545

The issue is the argument BETWEEN. Try this instead.

CASE 
  WHEN Donors >= Lower Budget Threshold AND Donors < Upper Budget Threshold
  THEN 'Normal'
  ELSE 'Outlier'
END