Skip to main content
Skip table of contents

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.

 

Example

Project default variables

$MY_VAR = 10

Nodes:

Node 1

Year

Measure

2020

$MY_VAR

2021

$MY_VAR

2022

$MY_VAR

2023

$MY_VAR

Node 2

Year

Measure

2020

1

2021

1

2022

1

2023

1

Result Node = Node 1 * Node 2

Year

Measure

2020

10

2021

10

2022

10

2023

10

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”)

Year

Base (Node 1 * Node 2) = (20*1)

2020

20

2021

20

2022

20

2023

20

BASELINE('Result Node', “PROJECT”)

Year

Base (Node 1 * Node 2) = (10*1)

2020

10

2021

10

2022

10

2023

10

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.