Variables/SA

[#1]

Hi,

I'm trying to get a count for the current and previous month using set analysis with a variable:

To get the current month-year:

date(today(),'MMM-YY')

Set analysis formula:

count({$<MonthYear = {$(vcurrmonth)}>}dc_code)

As far as I am aware the MonthYear and current month variable are in the same format.

Can anyone tell me what I am doing wrong?

Thanks.

[#2]

I resolved this - by removing the calendar dates from the set analysis which were skewing the figures.