Scenario:
One of the approver approves the timesheets for few users and would like to run a report that shows the total hours approved by the approver till date for all the users reporting to the approver.

Resolution:
To achieve this requirement, follow the steps given below:

  • Create a custom column in the Awaiting Approval report.
  • Name the custom column as Approved Hours.
  • Include the following formula in the custom column field,

if(ApprovalStatusCode=2, Total Hours,0)

  • Click the Grouping tab at the top.
  • Under the Summary Options, set the value for the custom column Approved Hours to Sum.
  • Click Save.
  • Run the report to get the expected data output.

Note: The custom column mentioned above will not work if there are multiple approvers approving the timesheets.