Omitting data based on "subsummary when sorted by values", is it possible?
I do a little Filemaker programming on the side for the company I work for and don't necessarily have an overwhelming knowledge of relational databases or filemaker so this may be a simple fix I'm hoping I've missed. The program I'm working on is an inventory tracking program. What I have is a database that has an individual record for each product for each shipment out and for each receiver coming in with a field "Inv_ModValue" which simply shows the quantity for receiving and (0-quantity) for shippers giving me a negative quantity. On my inventory report the current inventory is attained by a summary field =Total of Inv_ModValue within a subsummary part. Works great but I don't want products to display if they're month end value is 0. Any thoughts on the matter are greatly appreciated.