MOD
Description
MOD
is a row function that divides 2 LONG
or INTEGER
values and returns the remainder value of type LONG
or INTEGER
(the result is truncated to 0 decimal places).Syntax
MOD
(dividend
,divisor
)Return Value
Returns 1 value per row of type
INTEGER
if both input values are of type INTEGER
. Otherwise, returns 1 value per row of type LONG
.Input Parameters
- dividend
- Required. A field or expression of typeLONGorINTEGER.
- divisor
- Required. A field or expression of typeLONGorINTEGER.
Examples
Cast the value of the
file_size
field to LONG
and divide by 1024:MOD(TO_LONG([file_size]), 1024)