mod#

Description#

Returns the remainder when dividend is divided by the divisor.

Return type#

int64

Domain#

This is a scalar function (calculates a single output value for a single input row.)

Categories#

Usage#

mod(dividend, divisor)

Argument

Type

Optional

Repeatable

Restrictions

dividend

int64

no

no

none

divisor

int64

no

no

none

Examples#

make_col remaining:mod(@.billed_days, 7)

Create a column ‘remaining’ with the number of billed days that are not counted in weeks