AVERAGEA

The AVERAGEA function returns the arithmetic mean of the values in a column considering texts and non-numeric values.

Syntax

AVERAGEA(
    <column>
)

Parameters
  • column: Name of the column for which you want to calculate the arithmetic mean.
Returned value

The AVERAGEA function returns a real number.

Additional Information

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.

Examples

We start from the following table, Data :

AVERAGEA function. Example of use

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])

AVERAGEA function. Example of use

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.

Related functions
Category
Statistical
Submitted by admin on Wed, 01/09/2019 - 20:06