Summary fields in FileMaker: types, uses, and when to choose calculation instead

Beginner

Summary fields aggregate data across the current found set in real time. Learn the five summary field types, when to use a summary field vs a calculation, and why context matters for summary results.

What you'll learn

The five summary field types: Total, Count, Average, Maximum, Minimum
How summary fields respond to the current found set vs calculation fields
When to use a summary field vs a calculation with Sum()

Summary fields compute aggregates (total, count, average, min, max) across all records in the current found set — they update automatically as the found set changes and are the standard tool for reports.

1/2

Create a Total summary field

In Manage Database, add a field with type Summary. Choose "Total of" and select the numeric field to sum. Place it on a report layout to show the total for the current found set.

TEXT

// Summary field definition (in Manage Database > Fields):
// Field name:  totalRevenue
// Field type:  Summary
// Summary type: Total of
// Field:        Orders::amount

// On the layout:
// This field shows the sum of Orders::amount for all records
// in the current found set — it updates automatically

Custom functions in FileMaker: when to create them and recursion Stored vs unstored calculations in FileMaker: performance impact