Skip to main content
Skip table of contents

NONSIM

Basic Overview

AVAILABLE SINCE 6.0

Description

The NONSIM function returns the value for the inserted node with no assumptions applied. All nodes that affect this input node will have assumptions applied.

Signature

NONSIM(Node [, useVariablesFrom])

Parameters

  • Node: An input node

  • useVariablesFrom: A flag 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 NONSIM function. Any other nodes “up stream” in the full model will use a different value for the variable in their calculation.

  • The NONSIM function does not allow combinations of operations as it’s Node input.

Example 1

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

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 NONSIM function when calculating the model for the Scenario

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

Year

Base (Node 1 * Node 2)

2020

20*2=40

2021

30*3=90

2022

40*4=160

2023

50*5=250

NONSIM('Result Node', “PROJECT”)

Year

Base (Node 1 * Node 2)

2020

10*2 = 20

2021

(10+10)*3 = 60

2022

(10+20)*4 = 120

2023

(10+30)*5 = 200

JavaScript errors detected

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

If this problem persists, please contact our support.