Skip to Content

Turn your connections into holiday cash with our new Customer Referral Program! Learn more

✕

This documentation is for version 4 of App Builder, the new name for Vinyl. Access the Vinyl documentation here.

✕

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