Mod(Expression Function)

Purpose

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

Parameters

The Mod function has two required parameters:

Numerator

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.

Denominator

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.

Output

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

Example

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

expression function - mod.txt · Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2022