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.

✕

Sum() mvSQL database function in Jitterbit App Builder

Summary

Returns the sum of all the values, or only the DISTINCT values, in the expression.

Syntax

SUM(<column>)

SUM(DISTINCT <column>)

Parameters

column

The column to sum.

Remarks

SUM can be used with numeric columns only. Null values are ignored. With the optional DISTINCT modifier, only unique values are summed.

Returns

The sum of all values.

Examples

SUM(MonthlyExpenditures)

Returns

108.65