4 Replies Latest reply: Apr 10, 2013 6:44 AM by Luca Cavallari RSS

    Getting the total

      Hi All,

       

      I need to get the total of the values in my table. please see the sample table:

       

       

      Month YearFeb 2013Feb 2013Feb 2013Mar 2013Mar 2013Mar 2013
      NO400040004000400040004000
      Final CategoryCODEFILLEDBULKTotalFILLEDBULKTotal
      Beginning Balance
      1000100001100075527.00271,601.00347,128.00
      Transfer 500.00200.00700.0051201343454,635.00
      Gain 600.0024,453.0025,053.0023232564654587,886.00
      Loss 2004.005,949.007,953.0032321312335,444.00
      Purchase 62423.00239,999.00302,422.002312343242345,554.00
      Total 75527.00271,601.00347,128.00184593.001186054.001370647.00

       

      The red fonts in march are the total from feb. I need to set the beginning balance of the next month of the totals.

      feb beginning balance is already given.

       

      Thanks,

      Donna