COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Query Studio => Topic started by: Sandy10 on 16 Nov 2010 02:15:17 PM

Title: Filtering on > 0 or < 0 or <> 0
Post by: Sandy10 on 16 Nov 2010 02:15:17 PM
Hi, I would like to have a simple filter on a column to say > 0, for example.
The only way that I can achieve this, that I have seen, is to set the low value to .01, and then
the generated filter is >= .01.
Isn't there a simple > 0, < 0, and <> 0  ????

Thank you !!!
Title: Re: Filtering on > 0 or < 0 or <> 0
Post by: charlie on 18 Nov 2010 08:35:02 AM
Use the NOT condition (Do not show the following) in your filter with these values.

for > 0
From : lowest value
To: 0

for < 0
From: 0
To: Highest value

for <> 0
From: 0
To: 0
Title: Re: Filtering on > 0 or < 0 or <> 0
Post by: Sandy10 on 18 Nov 2010 01:06:43 PM
Hi Charlie.  Thank you !!  I do remember this, it's just not that intuitive.