RANGE
Last updated
Last updated
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.
.RANGE(start_index, end_index) - > [number]
| Arguments | Datatype | Description |
|---|---|---|
This function can only be used after refering a node for which this calculation needs to be done as shown below in the 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
To achieve this, the following formula should be written in the [Range Interest payments] node:
SUM([Interest payments].Range(4,6))
start_index
Number
The starting range/period value
end_index
Number
The ending range/period value
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
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