Quarter interest

[dandaanilreddy]

Hello  Qlik Developers,

For the selected quarter I have a refund amount but I want to calculate the interest starting from the next quarter minus 15 days.

Example: I have refund amount 1000$ for 12/31/2010 the interest should be calculated from the next quarter Q1 from date 1/15/2011 to 3/31/2011 i.e. is 75 days.

Can someone help me thanks in advance.

[Anonymous]

plz share the sample data ..

[manojkulkarni]

can you share some sample data with expected result, it will be more helpful to address