# NEGATE Function

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.

## Basic Usage

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

## Syntax

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

### value1

Integer or Decimal expressions, column references or literals.

• Missing or mismatched values generate missing string results.

Usage Notes:

Required?Data TypeExample Value
YesLiteral, function, or column reference returning an Integer or Decimal value`15`

## Examples

### Example - Numeric Functions

This example demonstrate the following numeric functions:

Source:

ValueAValueB
82
104
1510
56

Transform:

Execute the following transforms:

`derive type:single value:ADD(ValueA, ValueB) as:'add'`

`derive type:single value:SUBTRACT(ValueA, ValueB) as:'subtract'`

`derive type:single value:MULTIPLY(ValueA, ValueB) as:'multiply'`

`derive type:single value:DIVIDE(ValueA, ValueB) as:'divide'`

`derive type:single value:MOD(ValueA, ValueB) as:'mod'`

`derive type:single value:NEGATE(ValueA) as:'negativeA'`

`derive type:single value:LCM(ValueA, ValueB) as:'lcm'`

Results:

With a bit of cleanup, your dataset results might look like the following: