Negative / Operator Layer
Negate numeric values in a column (multiply by -1). Similar to Python's unary minus (-), pandas neg(), or R's negative operator. Creates a new column with reversed signs.
Mathematical form: where is the row index.
Common applications:
- Reversing price differences (gain to loss)
- Inverting measurement offsets
- Converting between opposite metrics
- Balancing credit/debit entries
- Reversing directional indicators
- Creating opposing force values
- Adjusting coordinate systems
Note: Applies to signed numeric types only. Unsigned integers result in null values.
Table
0
0
Table
Select
columnThe numeric column to negate. Common value types:
- Account balances (+400 → -400)
- Temperature differences (+5 → -5)
- Position offsets (+10 → -10)
- Growth rates (+2.5% → -2.5%)
Must be a signed numeric type
AsColumn
nameName for the new column. If not provided, the system generates a unique name. If AsColumn
matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.