Returns the modulo value, which is the remainder of dividing the first argument by the second argument. Equivalent to the |
NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Numeric Operators. |
derive type:single value: MOD(14,3) as:'two' |
Output: The remainder of the value 14
divided by 3
is stored in a new column called two
.
derive type:single value: MOD(value1, value2) |
Argument | Required? | Data Type | Description |
---|---|---|---|
value1 | Y | string | The first value must be an Integer or Decimal literal, column reference, or expression that evaluates to one of those two numeric types. |
value2 | Y | string | The first value must be an Integer or Decimal literal, column reference, or expression that evaluates to one of those two numeric types. |
Integer or Decimal expressions, column references or literals.
Required? | Data Type | Example Value |
---|---|---|
Yes | Literal, function, or column reference returning an Integer or Decimal value | 15 |