Excerpt |
---|
Returns the modulo value, which is the remainder of dividing the first argument by the second argument. Equivalent to the % operator. |
- Each argument can be a literal Integer or Decimal number, a function returning a number, or a reference to a column containing numeric values.
Info |
---|
NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Numeric Operators. |
D code |
---|
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
.
D code |
---|
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. |
value1, value2
Integer or Decimal expressions, column references or literals.
- Missing or mismatched values generate missing string results.
Required? | Data Type | Example Value |
---|
Yes | Literal, function, or column reference returning an Integer or Decimal value | 15 |
Example - Numeric Functions
Include Page |
---|
| EXAMPLE - Numeric Functions |
---|
| EXAMPLE - Numeric Functions |
---|
|