Math function: MOD

MOD

This function returns the remainder of a division.

Syntax

 number1 % number2

• number1 - Dividend; number or attribute of some type of number to be divided by another number value.

• number2 - Divisor; number or attribute of some type of number to divide by.

Return types

• number % number = number

• integer % integer = integer

• currency % currency = currency

• percentage % percentage = percentage

• number % integer = number

• integer % number = number

• currency % number = currency

• currency % integer = currency

• percentage % number = percentage

• percentage % integer = percentage

Examples

Suppose the following data model.