0 Replies Latest reply: Feb 27, 2013 8:08 AM by dbuijsman RSS

    Showing future payments (By interval)

      Hi,

       

      Im using a table from  an oracle database. This is a part of that table:

       

      PERIODPAYMENTSTARTDATEPERIODMONTHENDDATENEXTPAYDATELASTPAYDATEAMOUNT
      Subsidie 1e kw. 2013 1-1-2009 0:00331-12-2013 0:001-4-2013 0:001-1-2013 0:00124
      Stimuleringssubsidie afgewezen voor 20111-1-2003 0:00231-12-2010 0:001-1-2011 0:001-10-2011 0:001065
      Subsidie gestopt 1-1-2009 0:00131-12-2010 0:001-1-2011 0:001-12-2010 0:001081
      Subsidie 4e kw.2011 1-1-2009 0:00331-12-2011 0:001-1-2012 0:001-10-2011 0:00499
      Fractievergoeding 1e kw.20131-4-2006 0:00331-3-2014 0:001-4-2013 0:001-1-2013 0:00104,94
      Subs.aangepast sporten 1e kw. 20131-1-2003 0:00331-12-2013 0:001-4-2013 0:001-1-2013 0:001392
      subsidie 1e kw. 2013 1-4-2011 0:00331-12-2013 0:001-4-2013 0:001-1-2013 0:00463
      subsidie 1e kw. 201331-3-2010 0:00331-12-2013 0:001-4-2013 0:001-1-2013 0:004938

       

      I want to show the sum of the amount for each value from the column PERIODPAYMENT by the date, but als the payments in the future. The trick is the PERIODMONTH field, which shows the interval of the payment.

      So for example when i click on the year 2013 and click on the value 'subsidie 1e kw. 2013' i see sum of the amount by the following months: Jan, Mar, Jun etc.

       

      Does someone know how i can make this work?