2 Replies Latest reply on Feb 16, 2009 9:56 AM by PatrickHolzer

    Getting the total of fields depending on the value in another field

    PatrickHolzer

      Title

      Getting the total of fields depending on the value in another field

      Post

      Hi,

      My Goal:

      I'd like my FileMaker to return the total of pieces sold (field: "total_sold") for all of my products.

      Every order has one product to it (and only one), but has different quantities of that product. Also, an order always has a status (pending, returned, cancelled, etc.).


      The Problem:

      The challenge now is that I'd like only orders with the status "shipped" to be summarized in the field "total_sold".

      How can this be done?

      Thanks!

      - Patrick