DMOD, FMOD, and IMOD: Calculating the Remainder From a Division

How to:

The MOD functions calculate the remainder from a division. Each function returns the remainder in a different format.

The functions use the following formula. 

remainder = dividend - INT(dividend/divisor) * divisor
Top of page
x
Syntax: How to Calculate the Remainder From a Division
function(dividend, divisor, output_format)

where:

function

Is one of the following:

DMOD returns the remainder as a decimal number.
FMOD returns the remainder as a floating-point number.
IMOD returns the remainder as an integer.

dividend

Numeric

Is the number being divided.

divisor

Numeric

Is the number dividing the dividend.

output_format

Numeric

Is the result, whose format is determined by the function used.
Example: Calculating the Remainder From a Division

IMOD divides ACCTNUMBER by 1000 and stores the remainder in a column with the format I3L. 

IMOD(ACCTNUMBER, 1000, 'I3L')

For 122850108, the result is 108.

For 163800144, the result is 144.

iWay Software