Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
May be this
Count({<[Year/Month], Period = {"$(=Max(Period))"}+p({1<MONTH={'12'}>}), STATUS_CODE = {'ACTIVE'}, REG_TEMP = {'REG'}>} DISTINCT EMPLID)
May be this
Count({<[Year/Month], Period = {"$(=Max(Period))"}+p({1<MONTH={'12'}>}), STATUS_CODE = {'ACTIVE'}, REG_TEMP = {'REG'}>} DISTINCT EMPLID)