AVERAGE
Last updated
Last updated
The AVERAGE function returns the average (arithmetic mean) of its arguments, which can be numbers or node references.
AVERAGE(value1, ...valueN?) - > number
| 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. |
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])
