Home > Reference > Functions reference > Aggregate functions

Aggregate functions

Aggregate functions perform statistical analysis on numbers (and also 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 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
Average	The average of all valid, non-blank values in the specified field.
Count	The number of valid, non-blank values in the specified field.
List	The concatenation of all non-blank values in list form, separated by carriage returns.
Max	The highest valid value in a field or fields.
Min	The smallest valid non-blank value in a field or fields.
StDev	The standard deviation of a series of valid non-blank values in a field or fields.
StDevP	The standard deviation of a population represented by a series of valid non-blank values in a field or fields.
Sum	The total of all valid, non-blank values in the specified fields.
Variance	The variance of a series of valid non-blank values in a field or fields.
VarianceP	The variance of a population in a series of valid non-blank values in a field or fields.