Set Analysis - Replace a known with a variable

[jcharles]

Good day

I have the following set analysis that works:

COUNT({$<[REPORTED MONTH]={"Jul 2014"}>CASEID)

I have a variable that is as follows:

vCurrentMonth               =Monthname(today())

I want to replace "Jul 2014" with vCurrentMonth but when I do then the table shows no figures.

Please help.

[alexandros17]

The sysntax is this:

COUNT({$<[REPORTED MONTH]={$(vCurrentMonth)}>CASEID)

but I think it will not work because you need a format MMM YYYY while Monthname(today()) returns MMM

Insert the variable in a text box and verify its value

Let me know

[hic · Accepted solution]

There are many things that can go wrong here, but the following should work:

• Make sure that [REPORTED MONTH] is a dual field - created with MonthName() in the script.
• Use Count({$<[REPORTED MONTH]={'$(vCurrentMonth)'}> CASEID)

HIC

[jcharles]

Thank you