Sum Of Specific Values

[drummerob402]

Hi,

I am new to filemaker, but I am trying to find a way of creating a sum of all the fields that have a particular value for another field.

So for example, I want to total Field 1 in every record that has a 'yes' in Field 2.

How would I go about achieving this?

Thanks,

Rob

[Raybaudi]

Hi

1) create a calculation field ( I assume that its name is cConditionalField1 )

If ( Field2 = "yes" ; Field1 )

2) Create a summary field: total of cConditionalField1

Note that this summary field will sum all fields of the current found records count.