Case Function with ranges in beast mode

Anyone know why this is failing?

 

(CASE when `score`<=.2 then '2 or less'
when `score`>.2 and <=.5 then '2 to 5'
when `score` >.5 and <=.7 then '5 to 7'
when `score` >.7 and <=.8 then '7 to 8'
when `score` >.8 and <=.9 then '8 to 9'
when `score` >.9 and <=.99 then 'Over 9'
else 'other' end)

Comments

  • You need to define the column a second time after your "and".

    (CASE when `score`<=.2 then '2 or less'
    when `score`>.2 and `score` <=.5 then '2 to 5'
    when `score` >.5 and `score` <=.7 then '5 to 7'
    when `score` >.7 and `score` <=.8 then '7 to 8'
    when `score` >.8 and `score` <=.9 then '8 to 9'
    when `score` >.9 and `score` <=.99 then 'Over 9'
    else 'other' end)

    Let me know if you have any other questions,

    Valiant_Ronin

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.