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

    Syntax for using a variable into Set Analysis

    Hamish Imrie

      Hi,

       

      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?