1 Reply Latest reply: Sep 22, 2011 10:36 AM by Stefan Wühl RSS

    Accumulative columns

      I have 2 tables, 1 for daily transactions and 1 for opening balances. I require a field that accumulates the opening balance to the daily totals. In this way i will get the daily balance of the account.

      eg if the opening balance is 1000

       

      eff_datedaily totalaccumulative total
      1/09/20111001100
      2/09/20113001400
      3/09/20112001600