CUSTOMER ZONE

How do I create a report to show the allocation percentage of users in different projects?

Find resources designed to help you get the most from Replicon

Scenario:
The Web TimeSheet administrator needs to create a report that shows the hours entered by a user against each project as a percentage of the total hours entered by him for the month and would like the report to group rows by user name and project name and column by project name. Please find attached the screen shot of the report.

Resolution:
To resolve the issue, you cannot run any project report. Run the TimeSheet Detail report. Open the Settings page and enable the following fields:

  • Month (Entry Date)
  • Total Hours
  • Project Name
  • User Name
  • Total Hrs (In Month)

Create a custom column by named Percentage with the value TotalHours/ (TotalMonthHours).

Note: When you group rows by user name and then by project name and column by Project Name, you need to have user name set to none, total hours set to sum and percentage set to sum under Summary Options.

 

Start a free Replicon trial today based on your business needs

Start Free Trial