mod¶

Description¶

Returns the remainder when dividend is divided by the divisor.

int64

Domain¶

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

Usage¶

mod( dividend, divisor )


Argument

Type

Required

Multiple

dividend

int64

Required

Only one

divisor

int64

Required

Only one

Examples¶

make_col remaining:mod(@.billed_days, 7)


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