mod (modulus)

Type

Scientific Function

Purpose

The mod (modulus) function returns the remainder when one numeric value is divided by a second numeric value. If both values are integers, an integer value is returned. Otherwise, a decimal value is returned.

Syntax

mod( NUMERIC VALUE 1, NUMERIC VALUE 2)

Returns

A numeric value.

Usage

The numeric value in a Scientific function can be a constant value (as shown below), a variable, a field value, or an expression.

Examples

mod( 8, 3)

Returns: 2

mod( 12.6, 1.6)

Returns: 1.4