8 Replies Latest reply: Jul 20, 2016 4:27 AM by Anil Babu Samineni RSS

    How to range sum values?

      How to sum values per cut-off?

       

      Say, I have this list:

       

       

      DateAmount
      1/1/2013500
      1/3/2013400
      1/4/2013300
      1/9/2013600
      1/10/20131,000
      1/12/2013250

       

      How can I get the following values, if

       

      (1) When my date is 1/1/2013, the answer should be 500

      (2) When date selected is 1/2/2013, the answer is still 500

      (3) When date is 1/3/2013, the answer is now 900, because you should sum the previous amount

      (4) When date is 1/4/2013, the answer is now 1,200 - because you should always sum previous amount

       

      so on and so forth.

       

      Any one can help? Thanks.