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

Required

Multiple

Constant

dividend

int64

Required

Only one

Variable

divisor

int64

Required

Only one

Variable

Examples

make_col remaining:mod(@.billed_days, 7)

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