Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello
why do you use $(#,,,) try like this:
COUNT({$<AIF = {P}, LoadMonth_Active = {'$(ReportMonth)'}, Bucket={0,1,2,3,4,5,6}>} AIF)
Hello
why do you use $(#,,,) try like this:
COUNT({$<AIF = {P}, LoadMonth_Active = {'$(ReportMonth)'}, Bucket={0,1,2,3,4,5,6}>} AIF)
Thanks Sparur