Formula Help

[Former Member]

I am writing a report to show transfers of part numbers from one location to another.

Example would be... part AAAA is transfered "from" location 1110000 "to" location 1082000. It is grouped by a document number... the "from" location shows a quantity as a negative number and the "to" location shows as a positive number.

There are several thousand of these each month, from various location numbers to various location numbers, but I am only interested in finding transfers "from" a few certain locations "to" one location only.

For instance, I want to only see transfers from locations 1110000 and 1106000 and 1107000 and 1108000 "to" location 1082000.

Here is an example

ILLOCN Qty Trans Date

1739222 (Group document number)

0514070839R00 1041000 -80 9/1/08

0514070839R00 1105000 80 9/1/08

1739223

0540004209000 1106000 -1000 9/1/08

0540004209000 1082000 1000 9/1/08

I would like to be able to filter the above so I only see the second group (document number 1739223)

any suggestions out there?

[former_member260594 · Accepted solution]

Travis,

Try somthing like this;

( in [1110000 , 1106000 , 1107000 , 1108000] and < 0) or ( = 1082000

and

> 0)