Set Analysis not working

[shumailh]

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

[sparur · Accepted solution]

Hello

why do you use $(#,,,) try like this:

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

[shumailh]

Thanks Sparur