Functions Reference

Aggregate functions
F
ILEMAKER PRO FUNCTIONS REFERENCE 17
Aggregate functions
Note Aggregate functions perform statistical analysis on numbers (and dates or times for some
functions) in:
• several
fields in a record.
•
related fields whether displayed in a portal or not.
•
repeating fields.
For example, you can use the Sum function to add the values listed
in a portal, as an alternative to
creating a
report with grouped data and subtotals.
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.
Values in repetitions that exceed th
e 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
Average A value that is the average of all valid, non-blank values in a field.
Count The number of valid, non-blank values in a field.
List A concatenated list of non-blank values for a field or fields.
Max The highest valid value in a field.
Min The smallest valid, non-blank value in a field.
StDev The standard deviation of the sample represented by a series of non-blank values in
a field.
StDevP The standard deviation of a population represented by a series of non-blank values
in a field.
Sum The total of all valid, non-blank values in a field.
Variance The variance of a sample represented by a series of non-blank values in a field.
VarianceP The variance of a population represented by a series of non-blank values in a field.