U.M. (Windows)

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...)
1 The parameters field1, field2,... can include a numeric constant (for
example, 10). A constant in a formula for a repeating field affects the
result for every repetition.
1 When field1, field2,... includes a nonrepeating field, that value is used
in the result for only the first repetition unless you use the Extend
function. For information about the Extend function, see “Repeating
functions” on page C-11.
1 Empty (null) values are ignored.
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