# 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% |

Last updated