U.M. (Mac OS)

Summary of functions C-7
When you use aggregate functions, keep these points in mind:
1 You can specify fields in the current database (field) or in a related
database (relationship::field).
1 If you specify a single parameter (field) or (relationship::field), it
must be either a related field, or a repeating field. If you specify
multiple parameters (field1, field2,...) or (relationship::field1,
relationship::field2), they can be field references, a constant, or any
valid expression. If you specify related fields, you can name a
different relationship for each related field if you want
(relationship1::field 1, relationship2::field 2...)
Max (field)
Max (relationship::field)
Max (field1, field2,...)
Max (relationship::field1,
relationship::field2...)
Returns the highest nonblank value in a repeating field
(field) or (relationship::field)
Returns the highest nonblank value in each
corresponding repetition of one or more repeating or
non-repeating fields (field1, field2,...) or
(relationship::field1, relationship::field2...)
Min (field)
Min (relationship::field)
Min (field1, field2,...)
Min (relationship::field1,
relationship::field2...)
Returns the lowest nonblank value in a repeating field
(field) or (relationship::field)
Returns the lowest nonblank value in each
corresponding repetition of one or more repeating or
non-repeating fields (field1, field2,...) or
(relationship::field1, relationship::field2...)
StDev (field)
StDev (relationship::field)
StDev (field1, field2,...)
StDev (relationship::field1,
relationship::field2...)
Returns the standard deviation of the sample
represented by a series of nonblank values in a repeating
field (field) or (relationship::field)
Returns the standard deviation of the sample
represented by a series of nonblank values in each
corresponding repetition of one or more repeating or
non-repeating fields (field1, field2,...) or
(relationship::field1, relationship::field2...)
StDevP (field)
StDevP (relationship::field)
StDevP (field1, field2,...)
StDevP (relationship::field1,
relationship::field2...)
Returns the standard deviation of a population
represented by a series of nonblank values in a repeating
field (field) or (relationship::field)
Returns the standard deviation of a population
represented by a series of nonblank values in each
corresponding repetition of one or more repeating or
non-repeating fields (field1, field2,...) or
(relationship::field1, relationship::field2...)
Sum (field)
Sum (relationship::field)
Sum (field1, field2,...)
Sum (relationship::field1,
relationship::field2...)
Returns the sum of nonblank values in a single repeating
field (field) or (relationship::field)
Returns the sum of nonblank values in each
corresponding repetition of one or more repeating or
non-repeating fields (field1, field2,...) or
(relationship::field1, relationship::field2...)
Syntax Definition