Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to calculate the number of employees who was hired on the first day of the month (any month). They give me the fields and functions to use in set analysis: EMPLOYEE_ID, HIRE_DATE, day()
Please help me out to solve this problem.
Thank you.
@Pavanvh you are a quick learner. 🙂 Just 'distinct' is missed - I guess.
Count(Distinct {<HIRE_DATE={"=Day(HIRE_DATE)=1"}>} EMPLOYEE_ID)
Try Below
Count( {<HIRE_DATE={"=Day(HIRE_DATE)=1"}>} EMPLOYEE_ID)
@Pavanvh you are a quick learner. 🙂 Just 'distinct' is missed - I guess.
Count(Distinct {<HIRE_DATE={"=Day(HIRE_DATE)=1"}>} EMPLOYEE_ID)
Thank you @tresesco