Please enable JavaScript to view this site.

The ADD function adds two or more numbers together and returns the result of the addition operation. The plus sign (+) can also be used for addition and is the recommended operator.

Category

Mathematical

Syntax

ADD(addend1, addend2 [, addendn])

or

addend1+addend2+addendn

 

Parameter Descriptions

addend1-x  -  Two (2) or more numeric value from a source datastore field/column, user specified numeric value or the numeric result of another Function.

Example

Add source fields INPUT_NUM1 and INPUT_NUM2 and map the result to target field TGT_SUM. Assume that the values of INPUT_NUM1 and INPUT_NUM2 are 25 and 20, respectively.

TGT_SUM =  INPUT_NUM1 +  INPUT_NUM2

 

Returns the value of 45 and maps the result to the target field.

 

Add source field INPUT_NUM to the number 10 and map the result to target field TGT_SUM. Assume that the value of INPUT_NUM is 10.

TGT_SUM  =  ADD (INPUT_NUM, 10)

 

Returns the value of 25 and maps the result to the target field.