Working with Formulas > Functions Used in Formulas > List Functions
List functions are used for aggregate calculations (e.g., finding the average or sum of a group of numbers). Below are the list functions supported in the software:
Function Name
|
Type
|
Description
|
Avg()
|
List
|
Calculates the average of a list
|
Max()
|
List
|
Calculates the maximum value from a list
|
Min()
|
List
|
Calculates the minimum value from a list
|
Stddev()
|
List
|
Calculates the standard deviation of a list
|
Sum()
|
List
|
Calculates the sum of a list
|
Variance()
|
List
|
Calculates the variance of a list
|
|