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