Returns the value of subtracting the second argument from the first argument. Equivalent to the - operator.

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:SUBTRACT(10,4) as:'six'

Output: Subtracts the value 4 from 10 and stores the value in a new column called six

derive type:single value:SUBTRACT(value1, value2)

ArgumentRequired?Data TypeDescription
value1YstringThe first value must be an Integer or Decimal literal, column reference, or expression that evaluates to one of those two numeric types.
value2YstringThe 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 to use in the subtraction.

Required?Data TypeExample Value
YesLiteral, function, or column reference returning an Integer or Decimal valuemyScore * 10

Example - Numeric Functions