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