I have a list of records where I'd like to sum values from one of the fields but "in groups". Each group effectively shares a value in another field. If those other common values match, records in that subset of records are summed.
Here's an illustration of my data set and the calculation I'm trying to find.

Common value       Summed value       Sum result (calculation field)

1111                       5                             8

2222                      10                           33

1111                       3                             8

2222                      10                           33

2222                      13                           33

 

Thank you!

The simple way to do this is to sort the records by the "Common Value" field (which in Filemaker's language is called the break field). Then use a summary field, placed in a sub-summary part, to show the subtotal for each sorted group.

 

 

Edited April 4, 20178 yr by comment

I've considered that but my implementation requires Sum result to be picked up downstream via portal. I'm not working with a classic report layout.

SOLUTION: I moved my calculation field into the portal itself (since that was the implementation I needed in the first place), then it's just a matter of Sum() function targeting the portal field I needed to get total of. Since the portal already limits the records to the common value via relationship, that fixed my issue. Thanks.

Edited April 5, 20178 yr by McScripta

I am afraid you've lost me at this point.

14 hours ago, comment said:

I am afraid you've lost me at this point.

...I can hardly follow what I'm doing here myself. Thank you for your input!