4 Replies Latest reply on Jan 27, 2009 9:03 AM by Cstids

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

    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