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 and Description
| Parameter | Description |
|---|---|
| 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 1
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.
Example 2
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.