AVERAGE
The AVERAGE function returns the average (arithmetic mean) of its arguments, which can be numbers or node references.
Syntax
AVERAGE(value1, ...valueN?) - > number
Arguments
| Arguments | Data type | Description |
|---|---|---|
value1 | Node reference, number | The first node or number to be averaged. This is a required argument. |
...valueN? | Node reference, number | The additional nodes or numbers to be averaged. These are optional arguments. |
Example
Consider the below example in which the sales of a particular product across different regions East, South, Central and West are as follows. The average sales is to be calculated.
To achieve this, the following formula should be written in the [Average Sales] node:
AVERAGE([East],[South],[Central],[West])
Result
Last updated
