0 Replies Latest reply: May 5, 2014 1:55 AM by Chandrashekar Jakkula RSS

    Unble to accumulate records

      Hi all,

       

      we need solution on below mentioned issue. Attached file for your reference.


      Issue :

       

      1.     1. User enters end date in input box

      2.      2. Based on that end date written formula to arrive the correct closing balances.

      3. And we want to show another table last six months closing balances as showed below but unable to arrive month wise for the same

       

      MONTH_NAME

      Category

      B

      E

      R

      T

      S

      Total

      Jan 2014

       

      2,241,252

      230,890,138

      93,599,127

      2,777,919

        41,431

      329,549,867

      Dec 2013

       

      2,237,296

      219,561,433

      95,542,465

      3,138,738

        41,431

      320,521,362

      Nov 2013

       

      2,276,603

      214,331,505

      87,356,592

      2,744,862

        41,431

      306,750,994

      Oct 2013

       

      2,338,107

      212,351,117

      84,776,745

      3,503,767

        42,030

      303,011,765

      Sep 2013

       

      2,264,170

      209,458,750

      84,666,242

      3,031,464

        42,030

      299,462,656

      Aug 2013

       

      2,291,017

      209,975,734

      92,491,299

      3,996,015

      42029.6

      308,796,094