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

Comments

  • 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:

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


    **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!**