AVERAGEEXNEG

The AVERAGEEXNEG function returns the average (arithmetic mean) of its arguments excluding negatives, which can be numbers or node references.

Syntax

AVERAGEEXNEG(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 Profit of a particular product across different regions East, South, Central and West to be as follows. Assume if Profit for a particular period is negative, the product was withdrawn from the market and hence that region need not be considered for calculating average Profit.

To achieve this, the following formula should be written in the [Average Sales] node:

AVERAGEEXNEG([East],[South],[Central],[West])

Result

Average Excluding Negative