10 Replies Latest reply: Dec 3, 2012 10:54 AM by Aidan Marriott RSS

    Variables/SA

      Hi,

       

      I'm trying to get a count for the current and previous month using set analysis with a variable:

       

      To get the current month-year:

       

      date(today(),'MMM-YY')

       

       

      Set analysis formula:

       

      count({$<MonthYear = {$(vcurrmonth)}>}dc_code)

       

      As far as I am aware the MonthYear and current month variable are in the same format.

       

      Can anyone tell me what I am doing wrong?

       

      Thanks.