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