Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference SUM
Functions and Expressions Reference Guide
195
Uses
Use
SUBSTITUTE to replace a character with another character or to remove a
character.
Related Functions
LEAVEALPHA, LEAVEALPHANUM, LEAVENUM, LEAVEPRINT, SQUEEZE
SUM
The SUM function calculates the sum of a series of numbers.
Syntax
SUM ( series-number-expression )
Meaning
SUM ( series_to_sum )
Returns
This function returns a single-number.
The result is the sum of all the members in series_to_sum.
Example
SUM ( Quantity:LineItem )
This example calculates the sum of all the Quantity objects of LineItem.
Uses
Use
SUM when you need the sum of all the members of a series.