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

Author Topic: Filtering on > 0 or < 0 or <> 0  (Read 2823 times)

Sandy10

  • Guest
Filtering on > 0 or < 0 or <> 0
« 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 !!!

Offline charlie

  • Senior Member
  • ****
  • Join Date: Oct 2010
  • Posts: 74
  • Forum Citizenship: +3/-1
Re: Filtering on > 0 or < 0 or <> 0
« Reply #1 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

Sandy10

  • Guest
Re: Filtering on > 0 or < 0 or <> 0
« Reply #2 on: 18 Nov 2010 01:06:43 pm »
Hi Charlie.  Thank you !!  I do remember this, it's just not that intuitive.