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