Why won't this beast mode work -- case statement

CASE WHEN `Variable Name`<= 1 THEN 'SMALL'

 WHEN `Variable Name` BETWEEN 1 AND 1,000 THEN 'MEDIUM'

WHEN `Variable Name` > 1,000 'LARGE' END


  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🥷

    Domo's beast mode doesn't like the BETWEEN clause. Also, you are missing the THEN statement just before 'Large'. Try this:

    WHEN `Variable Name`<= 1 THEN 'SMALL'
    WHEN `Variable Name` >= 1 AND `Variable Name` <= 1000 THEN 'MEDIUM'
    WHEN `Variable Name` > 1000 THEN 'LARGE' 

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • GrantSmith
    GrantSmith Indiana 🥷

    You can't use commas in numerical comparisons. Also as @MarkSnodgrass mentioned you're missing a THEN in the last WHEN clause.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**