Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc


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

  • The 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.


D s

D code

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

D s

D code

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.

D s lang notes


Integer or Decimal expressions, column references or literals.

  • Missing or mismatched values generate missing string results. 

D s

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

D s

Example - Numeric Functions

Include Page
EXAMPLE - Numeric Functions
EXAMPLE - Numeric Functions

D s also