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