1 Reply Latest reply: Jan 5, 2013 1:54 AM by Phaneendra Kunche RSS

    Set Analysis Help

      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)

        • Re: Set Analysis Help
          Phaneendra Kunche

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