Daily Interest Calculation

[L_Hop]

Dear Qlikies,

I would like to calculate Interest amount using two different table.

I have some difficulties getting proper Interest_rates and day_of_interest. (interests are monthly basis)

I am looking for help to calculate interest amount? 

Interest Formula= Amount*interest_rate*day_of_interest/365*100

Sample data and expected results attached.

In addition to interest calculation, how can I find interest start and end date for per line in script side.

Any help would be greatly appreciated!

Thanks in advanced.

[L_Hop]

Dear Community,

I'm hoping someone can help me with a calculation. I am having trouble to match amount with proper interest day and rate. My interest rate table is monthly basis.

Any help/tips would be appreciated.

Interest calculation should be as follows;

Jan Calculation=( (31.01.2017 - 11.01.2017)+1)*Amount*Jan_Interest_Rate/365/100

Feb Calculation=( (28.02.2017 - 01.02.2017)+1)*Amount*Feb_Interest_Rate/365/100

Mar Calculation=( (31.03.2017 - 01.03.2017)+1)*Amount*Mar_Interest_Rate/365/100 ...

Pay/Receipt Date	Interest End Date	Interest Start Date	Amount
11.01.2017	18.05.2017	11.01.2017	-133,359

Interest_Rate	Rate_Start_Date	Rate_End_Date
3.53	01/01/2017	31/01/2017
3.55	01/02/2017	28/02/2017
3.64	01/03/2017	31/03/2017
3.66	01/04/2017	30/04/2017
3.69	01/05/2017	31/05/2017

best regards,

L_Hop