Description Adds the amount to each entry in the Node before any rollUps were done. Signature ADDEACH(Node, AmountNode) Parameters Node: Input node, specified using the node name in single quotes (e.g. 'Profit') Amount: The number to add to each entry. Available since 3.8.1: Amount can be another node.

## Examples

### Turn percentages into multiplication factors

5% is represented as 0.05 in Valsight. Factors, which are used for multiplication purposes, can be calculated by adding one to each percentage value.

Use ADDEACH('Percentage Node',1) to calculate the values.

DE 2% 102%
US 3% 103%

### Turn multiplication factors into percentages

Use ADDEACH('Index Node',-1) to calculate the values.

DE 102% 2%
US 103% 3%

### Calculate Splits

Suppose variable costs amount to 70% of the total cost. With this value stored, we can calculate the fixed cost (30% of total) using the ADDEACH function.

A 70% 30%
B 60% 40%

### Flip 0/1 helper tables

Sometimes a "True/False" or "1/0" helper table is needed. To reverse the input, we multiply the values by minus one and add one.

Country IS_EMEA ADDEACH(... * -1 ,1)
DE 1 0
US 0 1

### Using a node as amount input

Available since 3.8.1

Node =

Year Measure
2021 10
2022 100

AmountNode =

Year Measure
2020 100
2021 150
2022 200
2023 250