RANGE
The RANGE function refers to the values of a node between the specified start and end periods. We can use this function to find the values of certain periods.
Syntax
.RANGE(start_index, end_index) - > [number]
Arguments
| Arguments | Datatype | Description |
|---|---|---|
start_index | Number | The starting range/period value |
end_index | Number | The ending range/period value |
Remarks
This function can only be used after refering a node for which this calculation needs to be done as shown below in the example.
Example
Consider a scenario where we have interest payments for months Jan to Dec. Our objective is to calculate the interest paid in the months April to June.
| Periods | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
Interest payments | 0 | 78.37 | 74.06 | 69.71 | 65.33 | 60.91 | 56.46 | 51.96 | 47.43 | 42.86 | 38.26 | 33.61 |
To achieve this, the following formula should be written in the [Range Interest payments] node:
SUM([Interest payments].Range(4,6))
Result
Range Interest payments | 195.95 | 195.95 | 195.95 | 195.95 | 195.95 | 195.95 | 195.95 | 195.95 | 195.95 | 195.95 | 195.95 | 195.95 |
Last updated