View Source

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.

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.

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`

value1, value2

Example - Numeric Functions