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