COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Nickbruno on 16 Jul 2015 01:11:53 PM

Title: Operators "="
Post by: Nickbruno on 16 Jul 2015 01:11:53 PM
Hi, does the "=" operator work for multiple criteria? so...

[ORG]='10','12','15'

Will = work for multiple criteria or on one ex. just org 10?

If not is there a command that works to look for multiple criteria?

Thanks!
Title: Re: Operators "="
Post by: bus_pass_man on 16 Jul 2015 10:26:01 PM
try [ORG] in ('10','12','15')

The single quotes indicate that the values are strings.   If they are numeric you would not need to use them.  You ought to match the data type of the query item which you are using as the operand. 
Title: Re: Operators "="
Post by: Nickbruno on 17 Jul 2015 08:17:12 AM
Awesome! Worked Great!