The AVERAGEA function returns the arithmetic mean of the values in a column considering texts and non-numeric values.
AVERAGEA(
<column>
)
- column: Name of the column for which you want to calculate the arithmetic mean.
The AVERAGEA function returns a real number.
During the calculation of the arithmetic mean, the AVERAGEA function treats non-numeric values as follows:
- Values that evaluate to True are considered with the value 1.
- Values that evaluate to False are considered with the value 0.
- Values that contain non-numeric text strings are considered 0.
- Empty strings ("") count as 0.
If non-numeric values are not to be considered, the AVERAGE function should be used.
If there are no rows to calculate on, the function returns a BLANK. If there are rows, but none meet the required criteria, the function returns a 0.
We start from the following table, Data :
We can create a measure that calculates the arithmetic mean of the Value column using the AVERAGEA function on this data:
Avg = AVERAGEA(Data [Value])
Following the same example, if a True value were added to the table, the result would be the arithmetic mean of 2, 4, 1, 6, 1, that is, 2.8.