Administrators, writer
2,824
edits
Changes
Manuals/calci/Average, AverageA, AverageX Example (view source)
Revision as of 19:51, 19 October 2021
, 19:51, 19 October 2021no edit summary
<div style="font-size:16px">'''NOTE:'''</div>
<div style="font-size:16px">'''NOTE:'''</div>
The AVERAGEA function takes a column and averages the numbers, but also handles non-numeric data types according to the following rules:
The AVERAGEX function takes a column and averages the numbers, but also handles non-numeric data types according to the following rules:
*The function takes a table as its first argument, and an expression as the second argument.
*The function takes a table as its first argument, and an expression as the second argument.
*When there are no rows to aggregate, the function returns a blank. When there are rows, but none of them meet the specified criteria, then the function returns 0.
*When there are no rows to aggregate, the function returns a blank. When there are rows, but none of them meet the specified criteria, then the function returns 0.
*Does not support Logical/ boolean values.
*Does not support Logical/ boolean values.
'''AVERAGEA(A2:A5) = 2.5<br>
'''AVERAGEX(A2:A5) = 2.5<br>