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
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.
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