Average()

Format

Average(Number [,Numbers])

Note: This function was named Avg in v2.6.

Returns

Returns the average value of the variable number of arguments.

Inputs

Number: The argument whose values should be averaged.
Behaviour: Required
Dimension: Collection, SingleValue
Valid data types: Decimal, Integer 

Numbers: Additional arguments whose values should be averaged.
Behaviour: Optional (0..n)
Dimension: Collection, SingleValue
Valid data types: Decimal, Integer

How to format data types

Examples

Expression: Average(1,2)
Result: 1.5

Expression: Average(1,2,1)
Result: 1.33

Expression: Average({Tag1}, {Tag2})
Result: Returns the average value of the two tags.

 

Comments are closed