5 Replies Latest reply: Aug 2, 2014 1:34 PM by Massimo Grossi RSS

    Rangesum Above not working

    Steve Zagzebski

      I cant get range sum (above) to work properly.  I am including the table below.

      Amount column expression:  =sum(Amount)

      Amount (Rangesum above) expression:  =rangesum(above(sum(Amount),0,12))

      Amount Expected column: I added this to show how I would expect the range sum to work (current month plus accumlated total)

       

      Basically I just want to accumulate the amount column but I must be writing the expression incorrectly.

       

      MonthYearNumberAmountAmount (Range
        Sum Above)
      Amount Expected
      201301                703,619                                   703,619                 703,619
      201302             3,058,985                                4,466,223              3,762,604
      201303            (2,290,557)                               5,938,270              1,472,047
      201304                235,148                                7,645,465              1,707,195
      201305             2,404,384                              11,757,045              4,111,579
      201306            (1,542,086)                             14,326,538              2,569,493
      201307             1,559,486                              18,455,517              4,128,979
      201308                   (8,063)                             22,576,433              4,120,916
      201309                368,769                              27,066,118              4,489,685
      201310            (1,320,005)                             30,235,799              3,169,680
      201311                881,620                              34,287,100              4,051,300
      201312            (1,539,602)                             36,798,799              2,511,698

       

      Thanks in advance.