2 Replies Latest reply: Jul 24, 2013 5:34 AM by Tomer Kalimi RSS

    accumulated calculations problem

      I’m having some problem with accumulated calculations

      In the table below you can see the outcome of the accumulated calculation by checking the “full accumulation” check box in the expression.

      I need the accumulation calculation to be in the other way,

      From the bottom to the top.

       

      When I change the sorting, the accumulation calculation is changed, but then I have the latest date at the bottom and I like to have3it on the top.

       

      C_Date

      A_Accumulated

      A

      7/23/2013

      3,796

      3,796

      7/22/2013

      7,381

      3,585

      7/21/2013

      11,278

      3,897

      7/20/2013

      16,582

      5,304

      7/19/2013

      33,371

      16,789

      7/18/2013

      36,443

      3,072

      7/17/2013

      39,595

      3,152

      7/16/2013

      42,783

      3,188

      7/15/2013

      46,015

      3,232

      7/14/2013

      49,272

      3,257

      7/13/2013

      52,588

      3,316

      07/12/2013

      55,996

      3,408

      07/11/2013

      59,762

      3,766

      07/10/2013

      64,799

      5,037

      07/09/2013

      69,634

      4,835

      07/08/2013

      74,001

      4,367

      07/07/2013

      77,504

      3,503

      07/06/2013

      80,660

      3,156

      07/05/2013

      83,828

      3,168

      07/04/2013

      87,098

      3,270

      07/03/2013

      90,422

      3,324

      07/02/2013

      94,004

      3,582

      07/01/2013

      97,570

      3,566

       

       

      Thanks in advance.