AVERAGEEXNEG

Calculates the average of values while automatically excluding negative numbers to ensure more accurate analysis when only positive data should be considered.

The AVERAGEEXNEG function returns the average (arithmetic mean) of a set of values while excluding any negative numbers from the calculation. The arguments can be numeric values or node references. This function is commonly used when negative values should not impact the overall average, such as in performance metrics, financial analysis, or data quality evaluations.

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

Arguments

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

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

Example

AVERAGEEXNEG(COLUMN1, COLUMN2)

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

The average is calculated using only the positive values, with the negative values excluded, as shown in the highlighted example.

Applying AVERAGEEXNEG function

Excel equivalent

AVERAGEEXNEG