ADDEACH

ADDEACH

Description

Adds the amount to each entry in the Node before any rollUps were done.

Signature

ADDEACH(NodeAmountNode)

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

Was this helpful?

Yes | Somewhat | No