Set Analysis Help

[#1]

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)

[phaneendra_kunc]

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...