Hello everyone ,
I have to count the total number of rokkies in the company so i have these data:
1- count({<PERSON_TYPE_ID={6}>}distinct PERSON_ID) . (These for count Total employees)
2- I should subtract from Current Date -2
3- I should subtract Current date from Date Start if the result >=2 then count it as rookies
DateStart-Current date >=2 ,Count ({<PERSON_TYPE_ID={6}>}distinct PERSON_ID)
How can I solve it could you please help me!
