Basic Overview

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


FAQs

Frequently asked questions can be found here

Contact 

You may contact the Valsight Customer Support via:

+49 30 46799042

support@valsight.com

Availability: Mon-Fri *, 9 AM to 5 PM (Berlin, Germany) .

*Except Public holidays in Berlin, Germany.