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