Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual
Product codes
TJ083LL/A
Chapter 2
Aggregate functions
perform statistical analysis on numbers (and also dates or times for
some functions) in:
•
•
.
•
whether displayed in a
or not.
•
For example, you can use the Sum function to add the values listed in a portal, as an
alternative to creating a
The parameter values can include a numeric constant (for example, 10) or any valid
expression. A constant parameter in a formula for a repeating field affects the result for
every repetition.
When repeating field parameters (field1; field2;...) include a non-repeating field, that value
is used in the result for only the first repetition unless you use the Extend function, page
156.
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 referenced in the calculation has five repetitions.
Click a function name for details.
expression. A constant parameter in a formula for a repeating field affects the result for
every repetition.
When repeating field parameters (field1; field2;...) include a non-repeating field, that value
is used in the result for only the first repetition unless you use the Extend function, page
156.
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 referenced in the calculation has five repetitions.
Click a function name for details.
This function
Returns
The average of all valid, non-blank values in the specified field.
The number of valid, non-blank values in the specified field.
The concatenation of all non-blank values in list form, separated by carriage
returns.
returns.
The highest valid value in a field or fields.
The smallest valid non-blank value in a field or fields.
The standard deviation of a series of valid non-blank values in a field or fields.
The standard deviation of a population represented by a series of valid non-blank
values in a field or fields.
values in a field or fields.
The total of all valid, non-blank values in the specified fields.
The variance of a series of valid non-blank values in a field or fields.
The variance of a population in a series of valid non-blank values in a field or
fields.
fields.