Set Analysis Help

[#1]

I am to campare a field with two variable in set analysis but while camparing a field wrt two fields , i can  not able to convert the below expression in set analysis.

So please help me out..

((count(DISTINCT if(Emp_LeavingDate>= Quarter_Start and

Emp_LeavingDate<= Quarter_End and EMPLSTATUS = 0 and PAYSCALETY <> 'AP'

and PAYSCALETY <> 'TT'and PAYSCALETY <> 'T0',EMPLOYEE_Code)))

/

(((count(DISTINCT if(Emp_JoinningDate<= Quarter_Start and EMPLSTATUS = 3 and

PAYSCALETY <> 'AP'and PAYSCALETY <> 'TT'and PAYSCALETY <> 'T0',EMPLOYEE_Code))) +

  (count(DISTINCT if(Emp_JoinningDate<= Quarter_End and EMPLSTATUS = 3 and

PAYSCALETY <> 'AP'and PAYSCALETY <> 'TT'and PAYSCALETY <> 'T0',EMPLOYEE_Code))))/2))

*4

[fosuzuki]

The first count() should be translated to something like this:

count({<Emp_LeavingDate={">=$(Quarter_Start)<=$(Quarter_End)"}, EMPLSTATUS={0}, PAYSCALETY-={'AP','TT','T0'}>} DISTINCT EMPLOYEE_Code)

I guess it will not work at the first attempt... You'll have to check the format of the field Emp_LeavingDate and adjust the dollar-sign expansion of Quarter_Start and Quarter_End in a proper format.

The other count()'s are pretty similar, so if you get the first one you'll be able to adjust them.