Getting the total of fields depending on the value in another field
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 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?