Current period index returns the value of the period that is selected.
Consider the scenario where you want to calculate the Balance due for a loan taken for $40000.
Loan amount
40000
35000
30000
25000
21000
17000
14000
11000
8000
5000
3000
1000
Amount paid
4000
2000
To achieve this the following formula should be written in the [Balance due] node:
[Loan amount]-[Amount paid].GET(CURRENT_PERIOD_INDEX)
[Loan amount]
-
[Amount paid]
.
GET
(
CURRENT_PERIOD_INDEX
)
Balance due
0
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 2 years ago
Was this helpful?