0 Replies Latest reply: Mar 16, 2017 8:23 AM by Mia Sjölund RSS

    How get the right value in Ingoing balance

    Mia Sjölund

       

      Hi people!

       

      I really need some help here.      

      below is an example of what i want to achieve.

         

      yearIngoing Balancerecoded amount
      2017600100
      2016800-200
      2015500300
      2014800-300
      2013300500
      2012200100
      20110200

       

      I want to sum the recorded amount of all the previous years and put in the present years "Ingoing balance" column (so for year 2017, sum recorded amount until 2016), BUT i do not want the values in this column to be affected by any selections....

       

      I have tried Set analysis but I did not get it to work properly.

       

      Here is what I have tried so fara:

       

                    RangeSum(above(Sum({1<[Year]>} [Recorded amount]), 1, [Year] ))

       

      I think would like to make the entire expression a set...  

      I am super grateful for any suggestions!

       

      Thanks!