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

ArgumentsDatatypeDescription

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