5 Replies Latest reply: Jun 18, 2012 7:39 AM by Revlin Abbi RSS

    Set analysis with a variable

      Hi all


      Using set analysis, basic example below:

      =sum({$ < Year={2007} >} Sales)


      However, what I would like to do is instead of having the 2007 as an actual value I would like it to be based
      on the value of a variable say called var_year.

       

      I have tried:


      =sum({$ < Year={var_year} >} Sales)

       

      and I have tried:


      =sum({$ < Year= var_year >} Sales)


      But no luck. Any idea on how I can get this to work?

       

      Thanks

       

      Revlin