Average() mvSQL database function in Jitterbit App Builder¶
Summary¶
Returns the average of the values in a group. Null values are ignored.
Syntax¶
AVERAGE(<column>)
Parameters¶
column¶
A reference to a column.
Returns¶
The average of the column values. This function will always return a decimal, even if the column being averaged represents a whole number.
Examples¶
AVERAGE(Cost)
Returns
502.5