U.M. (Windows)

C-10 FileMaker Pro User’s Guide
Use GetSummary to:
1 create subsummary or grand summary values without using
subsummary or grand summary parts on a layout—you can see the
resulting values in the body part
1 perform mathematical calculations on a summary field
The following examples show the result of the GetSummary function. In
the first example, the file is sorted by the Department field first, and then
by the Last Name field. Department Subtotal is a calculation field:
GetSummary(Total Number, Department)
In the second example, the file is sorted by the Last Name field first, and
then by the Department field. Employee Subtotal is a calculation field:
GetSummary(Total Number, Last Name)
Total number of employees
in Direct Sales
Total number of
employees in Finance
This column displays the
Department Subtotal field