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