Friday, March 15, 2019

Saved Search that will Count number of employees hired on a specific date

Search: Count number of employees hired in a specific date.
1. Navigate to Lists > Search > Saved Searches > Employee.
2. Under Criteria tab, Standard subtab set Inactive is false.
3. Under Results tab, set the following:

Field = Formula (Numeric)
Summary Type = Count
Formula :

If the result needs to show employees hired in a specific month, try the formula below:

case when (to_char({hiredate}, 'MM/YYYY') < '06/2013') then {entityid} end

This will show how many employees with hire date of June 2013.

4. Click on Save & Run.

No comments:

Post a Comment