ABS
ABS('Node')
The ABS function returns the absolute value for each value in the input node.
Use this function when you need to remove the sign from negative values.
Parameters
- NodeNode referenceRequired
- Input node, specified using the node name in single quotes (e.g.
'Profit')
Example
Absolute value of positive, negative, and zero
This example shows that negative values become positive, while positive values and zero remain unchanged.
Input node: 'DecimalNode'
| Year | Value |
|---|---|
| 2025 | -24.5 |
| 2026 | 95 |
| 2027 | 0 |
Formula: ABS('DecimalNode')
| Year | ABS Result |
|---|---|
| 2025 | 24.5 |
| 2026 | 95 |
| 2027 | 0 |