3 Replies Latest reply: Mar 24, 2016 12:09 AM by anil y RSS

    CUMMULATIVE SUM IN GL BALANCES(conditional)

    anil y

      Dear all,

      I am working on G/L account balances data which has list Of G/L account and fiscal year and posting period.

              

      0000100000Equity Share Capital - Paid UpCEMK20082008122000000-15957450-139,57,450
      0000100000Equity Share Capital - Paid UpDIPK20082008120-383678500-3836,78,500
      0000110030Debenture Redemption ReserveDIPK20092008010-18750000-187,50,000
      0000110030Debenture Redemption ReserveCPPK200920091246875000-468750000
      0000110030Debenture Redemption ReserveDIPK200820081218750000-28125000-93,75,000
      0000110030Debenture Redemption ReserveDIPK20092009120-46875000-468,75,000
      0000110030Debenture Redemption ReserveDIPK2010201012750000000750,00,000
      0000110040General ReserveDIPK20092008010-150000000-1500,00,000
      0000110040General ReserveDIPK20112010010-540000000-5400,00,000
      0000110040General ReserveDIPK20122011010-350000000-3500,00,000
      0000110040General ReserveDIPK2009200808814-8140
      0000110040General ReserveDIPK2008200812150000000-560000000-4100,00,000
      0000110040General ReserveDIPK20092009120-100000000-1000,00,000
      0000110040General ReserveDIPK201020101275000000-750000000
      0000110050Profit & Loss AccountCEMK200820081281454274-52826891.06286,27,383

       

      I created a straight table. In this if my selection is single G/L account then I would like to have a cumulative sum based on fiscal year,and period.

      can you please suggest. tried range sum but result is not as expected.

       

      anil gopal