Page tree

Versions Compared

Key

  • 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

Excerpt

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.
Info

NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Numeric Operators.

 

D s
snippetBasic

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
snippetSyntax

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

value1

Integer or Decimal expressions, column references or literals.

  • Missing or mismatched values generate missing string results. 

D s
snippetusage

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

D s
snippetExamples

Example - Numeric Functions

Include Page
EXAMPLE - Numeric Functions
EXAMPLE - Numeric Functions

D s also
labelmath