AVERAGEEXNEG
Last updated
Last updated
The AVERAGEEXNEG function returns the average (arithmetic mean) of its arguments excluding negatives, which can be numbers or node references.
AVERAGEEXNEG(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 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])
