DELTA_ABS
Available from Valsight Version 6.13 (July 2025)
Description | Returns an absolute growth for each level value compared to its former level value based on the order in the dimension. |
Syntax | DELTA_ABS('Node', [“Dimension”, [“FirstValueBehavior”]]) |
Parameter |
|
Limitations |
|
Example
Input: Profit =
Year | Month | Product | Measure |
---|---|---|---|
2025 | 2025-11 | A | 1 |
2025 | 2025-11 | B | 2 |
2026 | 2026-04 | A | 20 |
2026 | 2026-05 | B | -10 |
Output: DELTA_ABS( ‘Profit’ ) = DELTA_ABS( ‘Profit’ , "Time" , "SKIP_FIRST") =
Year | Month | Product | Measure |
---|---|---|---|
2026 | 2026-04 | A | 19 (= 20 - 1) |
2026 | 2026-05 | B | -12 (= -10 - 2) |
Output: DELTA_ABS( ‘Profit’ , "Time" , "FIRST_AS_ZERO") =
Year | Month | Product | Measure |
---|---|---|---|
2025 | 2025-11 | A | 0 |
2025 | 2025-11 | B | 0 |
2026 | 2026-04 | A | 19 |
2026 | 2026-05 | B | -12 |
Output: DELTA_ABS( ‘Profit’ , "Time" , "FIRST_VALUE") =
Year | Month | Product | Measure |
---|---|---|---|
2025 | 2025-11 | A | 1 |
2025 | 2025-11 | B | 2 |
2026 | 2026-04 | A | 19 |
2026 | 2026-05 | B | -12 |