CURRENT_PERIOD_INDEX

Current period index returns the value of the period that is selected.

Example

Consider the scenario where you want to calculate the Balance due for a loan taken for $40000.

Periods
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec

Loan amount

40000

35000

30000

25000

21000

17000

14000

11000

8000

5000

3000

1000

Amount paid

5000

5000

5000

4000

4000

3000

3000

3000

3000

2000

2000

1000

To achieve this the following formula should be written in the [Balance due] node:

[Loan amount]-[Amount paid].GET(CURRENT_PERIOD_INDEX)

Balance due

35000

30000

25000

21000

17000

14000

11000

8000

5000

3000

1000

0

Explanation

As we used the current period index for Amount paid it will take Feb's value to subtract with Feb's loan amount, Mar's value to subtract with Mar's loan amount and so on.

Last updated