Mod

Computes the remainder of a division operation, dividing the first value by the second value Category: math Syntax:

Mod([x], [y])

Returns: Number Context Filtering: ✓ Yes

Parameters

Name	Type	Required	Description
`x`	`number or column`	✓ Yes	The dividend; the value that is divided
`y`	`number or column`	✓ Yes	The divisor; the value that is divided by. Non-zero

Allowed Column Types for x: INT, FLOAT, DECIMAL Allowed Column Types for y: INT, FLOAT, DECIMAL

Mod([X], [Y])

Returns the modulus for each pair of values in X and Y columns

Mod(19, 5)

19 divided by 5 has the modulus of 4 Result: 4

Mod(2, 3)

2 divided by 3 has the modulus of 2 Result: 2

Last modified on March 6, 2026