Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I resolved this - by removing the calendar dates from the set analysis which were skewing the figures.