4 Replies Latest reply: Jul 31, 2012 5:14 AM by Goran Korsgren RSS

    Syntax for using a variable into Set Analysis

    Hamish Imrie



      Please can somebody explain the difference between the following two statements:


      I tried to use a variable to calculate the previous months sales (based on MONTH Number.


      However the following expression is bringing back ALL MONTHS before the current month....

      sum({<CalendarMonthName =, CalendarMonthNumber = {'<= $(=v_Previous_Month)'}>} Sales)


      So after trial and error this expression works........ (brings back only the previous month)

      Sum({<CalendarMonthName=, CalendarMonthNumber={'$(v_Previous_Month)'}>} Sales)


      Does anybody have an insight into the difference between the above expressions?