Thanks a lot for the function. It's awesome. I'm still testing it out and trying to fix some problems.

Thank you all for looking into this. Below is a sample invocation of the function.

select ISNULL(dbo.fn_Looping_Function('10-10-2017', 0,'2015-08-24 00:00:00.000',12,1085.52,1085.54,100,13026.26,1),0)

This  is  expected to  give  me...

I'm really sorry that I did not post any code for reference. Below is the scalar function which has the loop to do calculation to find over due days based...