Please enable JavaScript to view this site.

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 Descriptions

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

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.

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.