Aggregate Functions
Aggregate functions apply to a group of fields in related records or repeating fields.
Syntax |
Data Type Returned |
---|---|
Average ( field {; field...} ) |
Number |
Count ( field {; field...} ) |
Number |
Max ( field {; field...} ) |
Text, Number, Date, Time, Timestamp |
Min ( field {; field...} ) |
Text, Number, Date, Time, Timestamp |
StDev ( field {; field...} ) |
Number |
StDevP ( field {; field...} ) |
Number |
Sum ( field {; field...} ) |
Number |
Variance ( field {; field...} ) |
Number |
VarianceP ( field {; field...} ) |
Number |