AVERAGEEXZERONEG
Last updated
Last updated
The AVERAGEEXZERONEG function returns the average (arithmetic mean) of its arguments excluding both zeros and negatives, which can be numbers or node references.
AVERAGEEXZERONEG(value1, ...valueN?) - > number
| Arguments | Datatype | Description |
|---|---|---|
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 Profit of a particular product across different regions East, South, Central and West to be as follows. Assume that if Profit for a particular period is negative or zero, the product was withdrawn from the market and hence that region need not be considered when calculating average Profit.
To achieve this, the following formula should be written in the [Average Sales] node:
AVERAGEEXZERONEG([East],[South],[Central],[West])
