Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to change this expression into set analysis.
=count(DISTINCT if((EMPLGROUP <> 9 and (EMPLSTATUS = '0' and PAYRL_AREA = '90'))
or
(FinYear = vMaxFinYear and Year_Month_new = vMaxMonthName and EMPLGROUP <> 9 and (EMPLSTATUS = '3' and (PAYRL_AREA = '68' or PAYRL_AREA = '72' or PAYRL_AREA = '74'
or PAYRL_AREA = '77' or PAYRL_AREA = '97' or PAYRL_AREA = '99')))
, EMPLOYEE_Code)
Try this...
count({<(EMPLGROUP-={9}>*(<EMPLSTATUS = {0}> * <PAYRL_AREA ={90}>))
+
(<FinYear = {'$(vMaxFinYear)'}> * < Year_Month_new = {'$(vMaxMonthName)'}> * <EMPLGROUP-={9}>* (<EMPLSTATUS = {3}>*<PAYRL_AREA ={'72','74','77','97','99'}> ) ) }
Disitnct EMPLOYEE_Code))
+ --- is OR
* --- is AND
above expression is not verified. test with your model...