What is the error in my beastmode?

Options

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

Best Answer

  • david_cunningham
    edited May 8 Answer ✓
    Options

    @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
    

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

Answers

  • david_cunningham
    edited May 8 Answer ✓
    Options

    @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
    

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**