U.M. (Windows)

Table Of Contents

C-8 FileMaker Pro User’s Guide

1 If you specify a single parameter (field) or (relationship::field), the

result includes all nonblank values in all repetitions. When the

calculation is also repeating, the result is returned in the first repetition.

1 When field1, field2,... are repeating and the calculation result is not

repeating, only the values from the first repetition of the repeating

fields are used to calculate the result. If the calculation result field is

also repeating, FileMaker Pro uses the corresponding repetitions of

the fields to calculate the result.

1 Values in repetitions that exceed the number of repetitions in the

calculated field are ignored. For example, a calculated field with three

repetitions holds only three results, even when one field in the

calculation has five repetitions.

The following examples show how aggregate functions produce results

based on the number of parameters and whether the calculations involve

repeating or nonrepeating fields.

Choose FileMaker Help Index from the Help menu, and then type:

E aggregate (statistical) functions

Example 1

Single input parameter

Example 2

Single input parameter

Repeating Field Sum(Repeating Field) Sum(Repeating Field)

10 10

Field Sum(Field) Sum(Field)

Field1 Field2 Field3 Sum(Field1, Field2, Field3)

Example 3

Multiple input parameters