Mod(Expression Function)

The Mod function (MOD) is used obtain the remainder of the division of one number by another.

The Mod function has two required parameters:

Allowed Inputs: field value or number

The first required parameter is the number that represents the numerator of the division operation. Either use the use the Query Builder to choose a field that contains the value or use type a value to enter a number.

Allowed Inputs: field value or a number

The second required parameter of the Mod function is the number that represents the denominator of the division operation. 0 is an illegal value for the denominator. Either use the query builder or the type a value option to enter a number.

The output of the Mod function is a number representing the remainder of the division operation.

For example MOD(8,3) would result in 2.