Scenario:
User has assigned department to a project but the billable amount should be  calculated according to the individual user rate not the department rate.

Resolution:
Create a new custom column in report which takes the user rate and billable hours to produce the desired output.

  • Click on Reports > Project Status Report > Settings.
  • Enable "User Default Billing Rate (BC)" under "User".
  • Disable "Billable Amt" under  "General".
  • Click on "ADD" to add a custom column and name it as "Total Billable Amt".
  • Copy and paste the following code.

UserDefaultBillingBaseRate*BillableHours

  • Click on "Save & Run Report".