Calculate Cumulative Principle Between 2 periods

kish87 — Sat, 16 Nov 2024 17:29:29 GMT

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

Re: Calculate Cumulative Principle Between 2 periods

Ksrinivasan — Fri, 12 Feb 2021 16:53:39 GMT

hi,

try this link

ksrini