2 Replies Latest reply: Jan 26, 2011 8:40 AM by Shumail Hussain RSS

    Set Analysis not working

      I was trying to filter my date by using set analysis but its not working.



      =COUNT({$<AIF = {P}, LoadMonth_Active = {$(#=ReportMonth)}, Bucket={0,1,2,3,4,5,6}>} AIF)


      this loadmonth_active contains months of year 2010 i.e. jan, feb, mar.... dec whereas the variable ReportMonth contains a value 'dec'.

      Earlier to that I tried loadday_active which contains days of last year with a variable ReportDay contains 31 which was working.

      I am unable to understand what is the reason why the month code is not working. Can anybody help me in this regard.

      Shumail