ADDEACH

Basic Overview

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.

Country	Inflation	ADDEACH(...,1)
DE	2%	102%
US	3%	103%

Turn multiplication factors into percentages

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

Country	Index	ADDEACH(...,-1)
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.

ADDEACH('Split' * -1,1)

Product	VarCostSplit	ADDEACH(.... * -1,1)
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.

ADDEACH('Original Values' * -1, 1)

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

ADDEACH('Node', 'AmountNode') =

Year	Measure
2021	160
2022	300