Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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