AnsweredAssumed Answered

How to sum a value in records with duplicate fields

Question asked by DarrenReiter on Jan 25, 2011
Latest reply on Jan 26, 2011 by philmodjunk

Title

How to sum a value in records with duplicate fields

Post

I'm crossing over from Access and I could use some help trying to do the following in Filemaker:

I have a database with several fields with the last field containing a numerical value.  The first two fields have many duplicates and where those duplicates exist, I would like to sum the values in the final field.

For example:

Field1 Field2 Field3

a b 10

a b 5

d e 20

d e 5

Becomes:

Field1 Field2 Field3

a b 15

d e 25

Outcomes