3 Replies Latest reply: Sep 18, 2012 8:12 AM by Jose Tos RSS

    Know debt situacion along the time: simulation. I need Help

      Hi, my name is Julio. Mi problem is next:

       

      i've this table

       

      InvoicePaid DateAmount
      INV-123/08/2012$1000
      INV-225/08/2012$2000
      INV-325/08/2012$1500
      INV-431/08/2012$500
      INV-5NOT PAID YET$3000

       

      All the invoices was made at 01/08/2012. I've other table, with a master calendar.

       

      I want design a graphic that It show, for each day in Agoust, hoy much it was the debt, like this:

       

      DateDebtExplication
      22/08/2012$8000All Invoices are not paid
      23/08/2012$7000INV-1 is paid
      25/08/2012$3500INV-1,INV-2,INV-3 are paid
      01/09/2012$3000Only the INV-5 is unpaid

       

      I need, in a graphic or in script, a table that, for each day in my calendar, have the sum of all invoices that aren't paid

      Thank you very much