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