mean()
Returns the mean value of all the passed parameters, excluding Nulls.
Syntax
mean(value, value2, ...,)
- value - the first value to be averaged.
- value2 - the second value to be averaged.
Return type: Number , Percent , Money.
Sample usage
mean(2, 10) returns 6.
Supported data types
Input type | Return type | Logic |
Number | Number | If a set of Number values is passed, the mean of the values will be returned as a Number value. |
Percent | Percent | If a set of Percent values is passed, the mean of the values will be returned as a Percent value. |
Money | Money | If a set of Money values is passed, the mean of the values will be returned as a Money value. |
Unsupported data types | Null | Unsupported data types return Null. |