Help with set analysis?

[Anonymous]

Hello,

Currently I'm using the following  expressions 

=count( {<REPORT_YEAR={$(vCurrentYear)>}AC_SERIAL)

I want to to include a condition ,which only shows values which older than or equal to current month,all other values must show null for future months

I know we have to you month(today()) function ,inside the set expression, but I running ionto syntax error

Thx

[#2]

I believe you would have to use month={">=$(=month(today())")}

[jagan · Accepted solution]

Hi,

If you have date field in your data then use this

=count( {<YearFieldName=, MonthFieldName=, QuarterFieldName=, DateFieldName={'<=$(=MonthEnd(Today()))'}>}AC_SERIAL)

Hope this helps you.

Regards,

Jagan.