COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: krisjontom21 on 09 Jan 2012 10:03:08 AM

Title: <>
Post by: krisjontom21 on 09 Jan 2012 10:03:08 AM
Using "<>" is what I would use to exclude a value, correct?  If so how would I write a filter for two values using "<>" ?
Title: Re: <>
Post by: Lynn on 09 Jan 2012 11:39:29 AM
One way: [YourDataItem] not in ('A','B')

Another way: [YourDataItem] <> 'A' and [YourDataItem] <> 'B'
Title: <>
Post by: MFGF on 10 Jan 2012 11:36:34 AM
Second way (and far less elegant than Lynn's)

[your data item] <> 'A' and [your data item] <> 'B'


Sent from my iPad using Tapatalk