Hi, first time on a site like this, but wanted to ask a question__
I am trying to group a range of scores (95-100) (90-94, etc.) but the suggestions are not working. I am trying CASE, and I am not able to get it to work. Any other suggestions?
CASE
WHEN([Monthly Average Score]) < .585) THEN ("0-59")
WHEN([Monthly Average Score]) < .695) THEN ("60-69")
WHEN([Monthly Average Score]) < .735) THEN ("70-74")
WHEN([Monthly Average Score]) < .785) THEN ("75-79")
WHEN([Monthly Average Score]) < .835) THEN ("80-84")
WHEN([Monthly Average Score]) < .885) THEN ("85-89")
WHEN([Monthly Average Score]) < .945) THEN ("90-94")
WHEN([Monthly Average Score]) < .975) THEN ("95-97")
WHEN([Monthly Average Score]) > .975) THEN ("98-100")
ELSE ("Other")
End
Thanks,
Amos
Try:
CASE
WHEN([Monthly Average Score]) < (585/1000)) THEN ('0-59')
....
....
ELSE ('Other')
End