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.
 •
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.
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.
Related topics