November 24, 2016 at 9:46 pm
Dear Expert,
i have data customer's installment like this
Require dateRequire amount
01/01/2016 100
05/01/2016 100
10/01/2016 100
and customer has few transaction to pay/withdraw.
Payment dateAmount
03/01/2016 $70.00
06/01/2016 $50.00
07/01/2016 $50.00
07/01/2016 $30.00
11/01/2016 $(40.00)
15/01/2016 $100.00
20/01/2016 $50.00
i would like to calculate the interest of this customer with (0.1% per lately day) for each time customer should pay for me. it's like how the bank calculate for their customer.
November 30, 2016 at 8:21 am
can you please describe (and explain) your expected results for this sample data
edit...what version of SQL are you using?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 15, 2016 at 12:41 pm
What are the full table layouts for the tables you are workign with including the indexed fields
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply