Can I run a report that shows the total hours approved by me till date for each user?
Find resources designed to help you get the most from Replicon
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.
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.