Check for negative number

Tom Aldridge toma at aldridgeinc.com
Fri May 21 18:47:08 PDT 2010


On 5/21/2010 8:28 PM, Jeff Harrison wrote:

> I'm not following.  If you want to find a negative value why don't you use a lookup "lt" the value of "0" ?
>
> If you want greater than zero, then do as you are doing now ("gt" a value of "0".  Is your problem you want to do both at the same time (excluding the value of 0 and blank?  If so I think you will need two lookups.
>
> Good Luck
>
> Jeff Harrison
> Author of JHImport and JHExport. The fastest and easiest ways to import and export with filepro.
>

Jeff,

Just wasn't thinking in terms of two lookups. Works. Thanks for the help.

Tom


More information about the Filepro-list mailing list