Dear Folks,
I need your help to achieve this calculation cumulative principle of a loan . Exactly similar to excel function CUMPRINC ( ).
Same function is being used by MIS reporting guy to identify principle amount between 2 periods.
like CUMPRINC ( rate, nper,pv,start period, end period, type)
Now i should replicate the same in qlik sense environment to automate the report.
where we have all the required components for calculation as shared below.
@sunny_talwar
@tresesco
@Gysbert_Wassenaar
Fyi.
| CUMPRINC() | cumulative principle calculation | Details |
| | | |
| pv | loan Amount | 100000 |
| rate | ROI | 7% |
| nper | Tenure Months | 48 |
| start_period | Start Month | 36 |
| end_period | End Month | 48 |
| | Paid Principle | -29721.8 |
Thanks!
Sai
