U.M. (Mac OS)

Summary of functions C-9
Summary functions
Use a summary function with summary fields.
When a database file is sorted, you can place a summary field in a
subsummary part to get subtotal values. (See “Adding a summary part”
on page 3-31.) Because sorting has the effect of grouping similar values,
the field you sort by is called a break field. FileMaker Pro calculates a
subtotal for each group of records with a common value in the break
field, letting you “break out” that range from the rest of the database.
Choose FileMaker Help Index from the or Help menu, and then type:
E aggregate (statistical) functions
Syntax Definition
GetSummary (summary field,
break field)
GetSummary (summary field,
summary field)
Returns the value of summary field for the current
range of records when records are sorted by break
field; otherwise, returns an empty result. This is
equivalent to calculating a subsummary.
Returns the value of summary field for the current
found set of records. This is equivalent to calculating
a grand summary.
A calculation using GetSummary is unstored.
Example 1
Single input parameter
Example 2
Single input parameter
Repeating Field Sum(Repeating Field) Sum(Repeating Field)
1
2
3
4
10 10
Field Sum(Field) Sum(Field)
5
55
Field1 Field2 Field3 Sum(Field1, Field2, Field3)
1
2
3
4
15
2
6
4
3
10
Example 3
Multiple input parameters