The MULTIPLY function multiplies two (2) or more numbers. The multiplication symbol (*) can also be used to perform this function and is the recommended method.
Category
Mathematical
Syntax
MULTIPLY(numeric_value1, numeric_value2 [, numeric_valuen])
or
numeric_value1 * numeric_value2 [*, numeric_valuen]
Parameter and Description
| Parameter | Description |
|---|---|
| numeric_value (1-n) | Two (2) or more numeric values from a source datastore field/column, user specified numeric value or the numeric result of another Function. |
Example 1
Multiply source fields INP_NUM1 (5), INP_NUM (10) and INP_NUM3 (2) and map the result in target field MULT_RESULT.
MULT_RESULT = INP_NUM1 * INP_NUM2 * INP_NUM3
Returns the value of 100 and maps it to the target field.
Example 2
Multiply the source field INP_NUM by 5 and map the result to target field MULT_RESULT. Assume that the field INP_NUM contains the value of 25.
MULT_RESULT = MULTIPLY (INP_NUM, 5)
Returns the value of 125 and maps it to the target field.