I have grouped my data by Part. Each Part is listed at the Branches that stock it, and each record has two more fields: Quantity Onhand, and 12-Month Demand. I want to eliminate records in two ways:

 

1. If there is no Quantity Onhand, I want to eliminate the Part, but only from the Branch where there is no Quantity.

 

2. If there is any 12-Month Demand in any branch, I want to eliminate all instances of that part. I use the sum function to find the total 12-month demand for each part.

 

Using the Select Expert creates a catch-22. If I eliminate
"Single Selection" based on Quantity Onhand, I create the possibility that these records contain Demand, which is now excluded from the sum, so I end up with parts that do have Demand. On the other hand, if I eliminate "Group Selection" based on Quantity Onhand, I remove every record for each part that is out of stock at even a single branch.

 

I need CR to consider the Demand for Parts that I've eliminated based on zero Quantity, and I can't figure out how!

 

Here's an example of what my data looks like:

 

 

01234567           10             0                      1

01234567           11             4                      0

 

76543210           20             6                      0

76543210           21             0                      0

 

I want to completely get rid of part 01234567 (because it has any demand) and I want to keep only the first record for 76543210.

 

Your help is greatly appreciated!

 

This will supress the line where if it finds  the demand is greater than 0.