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

Filtering on > 0 or < 0 or <> 0

Started by Sandy10, 16 Nov 2010 02:15:17 PM

Previous topic - Next topic

Sandy10

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 !!!

charlie

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

Sandy10

Hi Charlie.  Thank you !!  I do remember this, it's just not that intuitive.