4 Replies Latest reply: Dec 10, 2012 8:19 AM by Venkat Venkat RSS

    Need a running sum

      From 2 tabels (Bank account and Forecast)  I have the following information.

       

                 

      Date (T1 and T2)Current Account Balance (T1)Forecast (T2)Running Sum
      01/0110050100
      02/0111090110
      03/0100110
      04/01050160
      05/010- 40120
      06/0100120
      07/01080200

       

      I need a running sum (03/01) from the moment the last Current Balance is know.  How can this be calculated?

       

      Thanks

      John