4 Replies Latest reply: Dec 3, 2009 3:31 PM by PeterCrossley RSS

    Set Analysis

      example data:
      Period 1 has Value 1500
      Period 2 has Value 2500
      Period 3 has Value 3500

      the following expression:

      sum({$<Period = {1,2} >} Value)

       

       

      gives me the correct result of 4000 as it is selecting only Period = 1 and 2.





      I want to be able to select only Period 3 and for this set analysis to give me the result aggregation Period 1, 2 and 3, i.e. 7500.

      Therefore I want an expression to look at ALL Values where the Period is less than or equal (<=) to the current selection.