How to get missing timesheets of an Employee from the Weekly timesheet in a month

To create a saved search for missing timesheets of an employee based on the Weekly timesheet, the first step is to consider the Work Calendar Hours for each week.

Next, set the criteria as follows:

Under the Criteria subtab, choose the Formula (Numeric) filter.

The formula should be:

CASE WHEN {submittedhours}<{workcalendarhours} THEN 1 ELSE 0 END

Lastly, provide the description as equal to 1

Leave a comment

Your email address will not be published. Required fields are marked *