AnsweredAssumed Answered

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

Question asked by PatrickHolzer on Feb 13, 2009
Latest reply on Feb 16, 2009 by 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


Outcomes