4 Replies Latest reply: May 15, 2014 10:05 AM by Grant Perkins

# Filter question

I am trying to do a filter to exclude quantity and amount items when:

Quantity = 0 and Amount <= (absolute value) of 25.00 as there are both positive and negative numbers

any help here would be appreciated, seems like my process is not doing the filter properly

• ###### Filter question

Something like this?

Quantity<> 0 .And.

Abs(Amount)>25[/code]

• ###### Filter question

works some but not entirely

this is the normal data set i am working with

Qty   Amt

-1000000     -1072597.78

-10000     -10819.17

0     -25.06

3000000     42.64

0     6324.78

-250     -6332.59

250     6332.6

0     0.01

0     -0.03

80     4471.88

-80     -4471.89

110400     251734.08

0     -0.34

180     5232.88

-180     -5232.87

1000     0

0     1087.36

Qty Amount

-1000000     -1072597.78

-10000     -10819.17

3000000     42.64

-250     -6332.59

250     6332.6

80     4471.88

-80     -4471.89

110400     251734.08

180     5232.88

-180     -5232.87

valid 0 items are being removed plus other records that are not even quantity = to 0.

The only 0 items to be removed are the ones with amount <= 25.00

any suggestions?

• ###### Filter question

if i use the following it does what i want but i am afraid if i use the following it could whack me out,

let me know if that 3rd condition would work because when i had the first 2 conditions there was one item where qty = 1000 and the amount  = 0 and it was excluding it.

so i tried this, and it worked, but was wondering if it was a fluke?

initially i had the first part for a condition when <>0 to remove 0 items (amt+qty <>0) and then added the 3 other parts, it works from what i see, but just get nervous it may not be correct, though it is works

+<>0   .And.   (<> 0 .And. Abs()>25)    .Or.  (=0  .And. Abs()>25) .Or. (<>0  .And. =0)

• ###### Filter question

Try building each part of the filter separately and then combining them, one at a time, in a compound filter and compare the results at each stage. It may be the only way you can arrive at a comfortable feeling about whether the filter(s) give you what you want.

HTH.

Grant