documentationmod¶
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