AVERAGEEXZERO
Last updated
Last updated
The AVERAGEEXZERO function returns the average (arithmetic mean) of its arguments excluding zeros, which can be numbers or node references.
AVERAGEEXZERO(value1, ...valueN?) - > number
value1
Number/Node reference
The first node or number to be averaged. This is a required argument.
...valueN?
Number/Node reference
The additional nodes or numbers to be averaged. These are optional arguments.
Consider the sales of a particular product across different regions East, South, Central and West to be as follows. Assume if sales for a particular period is zero, the product was withdrawn from the market and hence that region need not be considered when calculating the average sales.
To achieve this, the following formula should be written in the [Average Sales] node:
AVERAGEEXZERO([East],[South],[Central],[West])
