Tuesday, November 13, 2018

Create a Search Displaying all Employees of a Department who entered less than 40hrs the previous week and/or no time entry at all and the Sum of time entered

Once we set a date field on the Criteria, the results only shows Employees who have at least 1 Time Entry record which removes all employees with no time entry entered during the week.

1.     Create an employee search by going to Transactions > Management > Saved Searches > New

2.     Select Employee

3.     On the Criteria tab > Summary sub tab : set the following for the fields:

Summary type > Sum
Field >
 Formula (numeric)
Formula > NVL({time.durationdecimal},0)
      Then set the Description to "Less Than = 40"

4.     On the Results tab > add the following fields:

Name, Summary type = Group
Summary type = Sum
   Formula = 


5.     Name the search

6.  Click on Save & Run

No comments:

Post a Comment