Set Analysis

[#1]

Hi Everyone,

I have EmployeeCode,GradeCode and Cal_Date fields,I want to find out employees Count who has same grade from last 3 years

Any suggestions would be greatly appreciated.

Regards,
P.Divya

[tresesco]

Something like:

Count({<EmployeeCode ={"=Count({<Cal_Date ={'>=$(=Date(AddYears(Max(Cal_Date ), -3))) <=$(=date(Max(Date)))'}>}Distinct GradeCode)=1 "}, Cal_Date ={'>=$(=Date(AddYears(Max(Cal_Date ), -3))) <=$(=date(Max(Date)))'}>}Distinct EmployeeCode)

Update: Include the same time set restriction in the inner count as well. Corrected few glitches as well.