AVERAGEEXZERONEG
The AVERAGEEXZERONEG function returns the average (arithmetic mean) of its arguments excluding both zeros and negatives, which can be numbers or node references.
Syntax
AVERAGEEXZERONEG(value1, ...valueN?) - > number
Arguments
| 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. |
Example
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])
Result
Last updated