3 Replies Latest reply: Sep 12, 2012 3:22 AM by Jason Michaelides RSS

    cumulative balance issue..

    sudeep dhoju

      APRIL

      MAY

      Opening Stock

      V1

      v2

      V3

      Balance

      Opening Stock

      V1

      V2

      V3

      Balance

      0

      10

      5

      3

      2

      2

      8

      2

      2

      6

        

       

       

       

       

       

      Here The opening stock in the 1st month is 0 and in the second month (i.e may) is the value of balance in previous month(i.e april) and balance is calculate by formula column(1)+column(2)-column(3)-column(4),

            where column(1)= opening stock

                           coluimn(2) =V1

                           column(3)=V2

                             column(4) = V3

       

       

      What should be the expression for the Opening stock(i . e column(1))??

       

      Note: If i select May, the value of opening stock still should remain 2 ,not 0

       

      Any help would be appreciated

       

       

      Thanks

      Sudeep