4 Replies Latest reply: Aug 16, 2010 5:19 PM by Henry Noh RSS

    SYNTAX for applying a SET MODIFIER to a VARIABLE

      I created a variable 'vYTD' which equals the latest month of the current year (assume for example the number '7')

      I'd like to write an expression such that I can automatically call up the previous month using set analysis so I'm hoping to get something like:

      Sum({<Month={$(vYTD)-1}>}Sales)

      This syntax does not seem to be working. Can someone advise? Thanks in advance.