Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
There are many things that can go wrong here, but the following should work:
HIC
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
There are many things that can go wrong here, but the following should work:
HIC
Thank you