p() and max()

[rmuhammad]

Hi

How do I select only the select month + dec from previous years? I tried but it didnt work

I am getting all Decembers but missing current select month

Count({<[Year/Month],Period=

,Period={'=$(=max(Period))'}

,Period*=P({1<MONTH={$(=12)}>}Period)

,STATUS_CODE={'ACTIVE'}

,REG_TEMP={'REG'}

>} distinct EMPLID)

[sunny_talwar · Accepted solution]

May be this

Count({<[Year/Month], Period = {"$(=Max(Period))"}+p({1<MONTH={'12'}>}), STATUS_CODE = {'ACTIVE'}, REG_TEMP = {'REG'}>} DISTINCT EMPLID)