Calculate Cumulative Principle Between 2 periods

[kish87]

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 

@tresB 

@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

[Ksrinivasan]

hi,

try this link

https://community.qlik.com/t5/New-to-Qlik-Sense/Calculating-Cumulative-Returns-in-Qlik-Sense/td-p/15...

ksrini