Functions Reference

FILEMAKER FUNCTIONS REFERENCE 27
If the calculation result isn’t a repeating field:
• Sum(Field2) returns 26.
• Sum(Field1;Field2;Field3) returns 12.
If the calculation result is a repeating field:
• Sum(Field2) returns a repeating field with 26 in the first repetition.
• Sum(Field1;Field2;Field3) returns a repeating field with 12, 8, 7, 8.
Note When a referenced field is a repeating field, the Sum function returns the sum of the first
repetition field, then the sum of the second repetition field, and so on.
Related topics
Contents
Functions reference (alphabetical list)
Variance
Purpose
Returns the variance of a sample represented by a series of non-blank values in field.
Format
Variance(field{;field...})
Parameters
field - any related field, repeating field, or set of non-repeating fields; or an expression that returns
a field, repeating field, or set of non-repeating fields.
Parameters in curly braces { } are optional.
Data type returned
number
Originated in
FileMaker Pro 7.0
Description
The variance of a distribution is a measure of how spread out the distribution is. Field can be any
of the following:
• a repeating field (repeatingField).
• a field in matching related records specified by (table::field), whether or not these
records appear in a portal.
• several non-repeating fields in a record (field1;field2;field3...).
• corresponding repetitions of repeating fields in a record
(repeatingField1;repeatingField2;repeatingField3), if the result is returned
in a repeating field with at least the same number of repeats.