Case Function with ranges in beast mode

user06299

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)

BlueRooster

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.