BASELINE

Basic Overview

AVAILABLE SINCE 6.0

Description	The BASELINE function returns the value for the inserted node with no assumptions applied, as well as all nodes that affect the input node have no assumptions applied.
Signature	BASELINE('Node' [, useVariablesFrom])
Parameters	Node: An input node useVariablesFrom: A string value determining if any variables used by the input node (and nodes that affect the input node) should be applied using their overridden value (if applicable) or the default project value. Valid inputs are: “SCENARIO”: Any variables used in the calculation will use values overridden by the scenario, if available. This is the default value. “PROJECT”: Use the project default values.
Limitations	If the node's associated model has multiple baselines, the baseline of the scenario is used. If using “PROJECT” for the ‘useVariablesFrom’: the variable will only use the project default values for the nodes calculated within the BASELINE function. Any other nodes “up stream” in the full model will use a different value for the variable in their calculation. The BASELINE function does not allow combinations of operations as it’s Node input.

Project default variables

$MY_VAR = 10

Nodes:

Node 1

Node 2

Result Node = Node 1 * Node 2

Note: Results above are the baseline results, i.e. with no assumptions applied.

Variable override via scenario and assumptions

$MY_VAR = 20

Scenario Assumptions

Node 1 (with overridden $MY_VAR as 'Base' and activated assumptions as 'Change')

Year	Base	Change	Result
2020	20	0	20
2021	20	10	30
2022	20	20	40
2023	20	30	50

Node 2 (with the initial measures as ‘Base’ and activated assumptions as ‘Change’)

Year	Base	Change	Result
2020	1	1	2
2021	1	2	3
2022	1	3	4
2023	1	4	5

Result Node (with the results of the calculation as ‘Base' and activated assumptions as 'Change’)

Year	*Base (Node 1 Node 2)**	Change	Result
2020	20 * 2	5	45
2021	30 * 3	5	95
2022	40 * 4	5	165
2023	50 * 5	5	255

Calling the BASELINE function when calculating the model for the Scenario

BASELINE('Result Node') = BASELINE('Result Node', “SCENARIO”)

BASELINE('Result Node', “PROJECT”)