Returns the opposite of the value that is the first argument. Equivalent to the - operator placed in front of the argument.

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: NEGATE(MyValue) as:'oppositeOfMyValue'

Output: The opposite of the value in the MyValue column is stored in a new column oppositeOfMyValue

derive type:single value:NEGATE(value1)

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.


Integer or Decimal expressions, column references or literals.

Required?Data TypeExample Value
YesLiteral, function, or column reference returning an Integer or Decimal value15

Example - Numeric Functions