If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

grouping scores in ranges in report studio

Started by Amos76, 23 Nov 2009 11:57:26 AM

Previous topic - Next topic

Amos76

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

blom0344

Try:



CASE
WHEN([Monthly Average Score]) < (585/1000)) THEN ('0-59')
....
....
ELSE ('Other')

End