Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Calculate Cumulative Principle Between 2 periods

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.






CUMPRINC()cumulative principle  calculation Details
pvloan Amount100000
nperTenure Months48
start_periodStart Month36
end_periodEnd Month48
 Paid Principle-29721.8





1 Reply