AVERAGE function
This topic describes the formula syntax and usage of the AVERAGE function in the Data Quality Execute Formula transform.
Description
Returns the average of the its arguments. Returns the average (arithmetic mean) of the arguments. For example, if the range of temperatures for a location, day 1 through day 4, contains temperatures, the formula AVERAGE([Day1],[Day2],[Day3],[Day4]) returns the average temperature for the four days.
Syntax
AVERAGE(number1,number2,...)- number1 Required. The number, column reference, or column range to average.
- number2,... Optional. The number, column reference, or column range to average.
- Arguments that are error values or text that cannot be translated into numbers cause errors.
Notes
- If a field referenced by a range or column argument contains text, logical values, or empty cells, those values are ignored. Cells with the value zero are included.
Example
Data:
Y1=4, Y2=5, Y3=6, Y4=7, Y5=5, Y6=3| Formula | Result |
|---|---|
AVERAGE([Y1],[Y2],[Y1],[Y3],[Y4],[Y5],[Y6]) |
5 |
AVERAGE([Y1]:[Y2]:[Y3],[Y4],5,3) |
5 |