Get

The GET function returns the value of the node corresponding to the period index that is specified.

Syntax

.GET(period_index) - > number

Arguments

Arguments	Datatype	Description
period_index	Number	An integer that is less than the number of periods defined in the model.

Remarks

This function can only be used after referring a node for which this calculation needs to be done as shown below in the example.

Example

Consider a scenario where you have the Discount rates for each period of 2023. The objective is to take the Dec 2023 rate as the discount rate for all periods of 2024.

Periods	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sept	Oct	Nov	Dec
Discount (2023)	10%	12%	12%	11%	12%	12%	13%	12%	10%	11%	13%	12%

To achieve this, the following formula should be written in the [Discount(2024)] node,

[Discount (2023) ].Get(12)

Result

Periods	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sept	Oct	Nov	Dec
Discount (2024)	12%	12%	12%	12%	12%	12%	12%	12%	12%	12%	12%	12%