Can anyone help with a Gridview Formula? I'm trying to accomplish this using *IC Item Loc w IC Item.

If the quantity on hand is greater than zero at location 60 or 61 or 62 or 63, then display the item.

Hi Susan,

The 'Quantity by Location' data file (or IC Item Loc) stores separate records for each item / location combination. So for a particular item number, there are 4 separate records - one each for locations 60, 61, 62 or 63.

The best you could do is create 4 calculated columns - one for each location. The syntax would be similar for each (eg for Calc column titled 'Loc60'):
IF( {Loc}="60",{Qty on Hand Plus},0)

This would put the qty on hand for each location into columns. Then summarize the view by Item number. Thus you would see one row for each item number and the display of the qty for each location.

Finally, do a filter that requires any of the 4 calculated columns to be non-zero:
OR(Loc60>0,Loc61>0,Loc62>0,Loc63>0)

A quick way of deciding whether any of a set of values is greater than zero is:

which will be "TRUE" if any of the values are greater than zero (assuming none can be negative).