AnsweredAssumed Answered

Omitting data based on "subsummary when sorted by values", is it possible?

Question asked by Cstids on Jan 27, 2009
Latest reply on Jan 27, 2009 by Cstids

Title

Omitting data based on "subsummary when sorted by values", is it possible?

Post

  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.

 

 

-Cody

 

Outcomes