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

Average