Please enable JavaScript to view this site.

The DIV function divides one number by another and returns the result, including the remainder in a user specified precision. The divide symbol (/) can also be used for division and is the recommended operator unless level of precision must be specified.

Category

Mathematical

Syntax

DIV(dividend, divisior, scale)

or

dividend/divisor

 

Parameter Descriptions

dividend  -  This parameter specifies the number that is to be divided.

divisor  -  This parameter specifies the number that will be used to divide the source number (dividend).

scale  -  Specifies the precision (the number of digits right of the decimal point) to be returned with the result of the divide operation.

Example

Divide INPUT_NUM1 (30) by INPUT_NUM2 (8) and return the result with a precision of 2. Map the result to target field RESULT.

RESULT  = Input_Num1 /  Input_Num2

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

Divide 25 by 8 and return the result with a precision of 3 and map the result to target field RESULT.

RESULT  = DIV (25,8,3)

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