ADDEACH
ADDEACH('Node', Amount)
ADDEACH('Node', 'AmountNode')
The ADDEACH function adds a numeric value (or the values of another node) to each individual entry of a node before any aggregation is applied.
Use this function when you need to apply an entry-by-entry adjustment to every value of a node while preserving the node’s dimensionality: ADDEACH('Growth Rate', 1).
Parameters
- NodeNode referenceRequired
- The input node, referenced by name in single quotes (e.g.
'Profit') - Amount / AmountNodeNumber or node referenceRequired
- A numeric value or another node to add to each entry
Output shape
- Dimensionality
- Preserves the input shape
- Values
- Each value of the node is increased by the specified amount
- Row count
- Same number of rows as the input node
Watch out
-
ADDEACH performs entry-by-entry addition before rollups (automatic aggregation up hierarchies, e.g. months summing to quarters).
-
The
+operator adds values after rolling them up to a common level. For example:'Node' + 5first aggregates Node to a single total, then adds 5 once.ADDEACH('Node', 5)adds 5 to every individual row before any aggregation.
-
When using another node as the Amount, the operation matches values across shared dimensions only.
Examples
Convert a percentage to a factor
A growth rate of 5 % is stored as 0.05 in Valsight.
To use it as a multiplication factor (1.05), add 1.
Formula: ADDEACH('Growth Rate', 1)
| Year | Growth Rate | ADDEACH Result |
|---|---|---|
| 2024 | 0.03 | 1.03 |
| 2025 | 0.05 | 1.05 |
| 2026 | 0.02 | 1.02 |
Reverse a factor back to a percentage
Formula: ADDEACH('Factor', -1)
| Year | Factor | ADDEACH Result |
|---|---|---|
| 2024 | 1.03 | 0.03 |
| 2025 | 1.05 | 0.05 |
Compute the complement (1 − x pattern)
Goal: Compute 1 minus each value (e.g. if a share is 0.70, the complement is 0.30).
Why not 1 - 'Split'? In Valsight, that expression first rolls up ‘Split’ into a single total, then subtracts.
Solution: Negate first with 'Split' * -1, then add 1 to each entry.
Formula: ADDEACH('Split' * -1, 1)
| Product | VarCostSplit | ADDEACH Result |
|---|---|---|
| A | 0.70 | 0.30 |
| B | 0.60 | 0.40 |
Variable costs are 70 % / 60 % of total cost The formula therefore yields the fixed-cost share (30 % / 40 %).
Flip 0/1 helper tables
To invert a binary helper table (1 → 0, 0 → 1), apply the same pattern.
Formula: ADDEACH('Original Values' * -1, 1)
| Country | IS_EMEA | ADDEACH Result |
|---|---|---|
| DE | 1 | 0 |
| US | 0 | 1 |
Useful when you need the logical opposite of an existing flag, e.g. turning an IS_EMEA flag into a NOT_EMEA flag.
Using a node as amount input
Instead of a fixed number, you can pass a second node. ADDEACH then adds the values element-wise, matching on shared dimensions. Where the Amount node has no matching value, the original Node value is kept unchanged. Rows that exist only in the Amount node are not included in the result.
Node
| Year | Value |
|---|---|
| 2025 | 10 |
| 2026 | 100 |
| 2028 | 50 |
AmountNode
| Year | Value |
|---|---|
| 2024 | 100 |
| 2025 | 150 |
| 2026 | 200 |
| 2027 | 250 |
Formula: ADDEACH('Node', 'AmountNode')
| Year | ADDEACH Result |
|---|---|
| 2025 | 160 |
| 2026 | 300 |
| 2028 | 50 |
Year 2024 and 2027 are absent because they only exist in AmountNode. Year 2028 has no match in AmountNode, so the original Node value (50) is preserved.
The overlapping years are summed entry by entry:
10 + 150 = 160
100 + 200 = 300
See also
- ADDITION (+)
- When you want to add two nodes after rollup.
- MULTIPLICATION (*) / MULTIPLY
- When you need element-wise multiplication instead of addition.
- ROLLUP
- When you want to aggregate values after element-wise operations.
- EXPAND
- When you need to add dimensional detail before applying ADDEACH.