Qlik Community

App Development

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

cancel
Showing results for 
Search instead for 
Did you mean: 
kish87
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.

@sunny_talwar 

@tresesco 

@Gysbert_Wassenaar 

 

Fyi.

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

 

Thanks!

Sai

 

1 Reply