AVERAGEEXZERONEG

Calculates the average of values while excluding both zero and negative numbers to focus only on meaningful positive data in your analysis.

The AVERAGEEXZERONEG function returns the average (arithmetic mean) of a set of values while excluding both zero and negative numbers from the calculation. The arguments can be numeric values or node references. This function is commonly used when only positive values should be considered, such as in performance metrics, financial analysis, or scenarios where zero and negative entries represent missing, invalid, or non-relevant data.

Syntax

averageexzeroneg(value1,[value2]....)

Arguments

value1 – The first node or number to be averaged (Required).

value2,...– The additional nodes or numbers to be averaged (Optional).

Example

AVERAGEEXZERONEG(COLUMN1, COLUMN2)

In the example below, the Average Values measure is created using the AVERAGEEXZERONEG function, which returns the average value of the four quarters while excluding both zero and negative values.

The average is calculated excluding the zero and negative values, as shown in the highlighted example.

Applying AVERAGEEXZERONEG function

Excel Equivalent

AVERAGEZERONEG