4 Replies Latest reply: Apr 18, 2016 4:07 AM by Sunny Talwar RSS

    Accumultation / running totals

    Ian McGivern

      Good Day,

       

      I'm having a head scratcher with regards to accumulation.

       

      It is working when no selections on i.e. Year is made.

       

      YearAmountAccumulation
      2010100100
      2011200300
      2012300600
      20134001000
      20145001500
      20156002100
      20167002800

       

       

      The goal is to have a selection made on Year (i.e. 2015 and 2016) and have it with the same accumulation / running total figures as above.

       

      The Accumulation expression so far:

       

      RangeSum(Above(Total

      Sum(

           {<

           >}

               Amount)

      , 0, RowNo(Total)))

       

       

      Unfortunately doing the logic in the script is not an option (the real solution enables users to make various filter selections).

       

      I have attached a sample QVF.

       

      Example of required result:

       

      Selection made: 2015, 2016

       

      Desired result:

       

      YearAccumulation
      20152100
      20162800