Actual hours - custom calculation | Community
Skip to main content
Level 2
February 19, 2020
Question

Actual hours - custom calculation

  • February 19, 2020
  • 1 reply
  • 477 views
Hi dear community, I have set a new report to reflect the Budgeted vs Actual in a project. In the Actual Hours field i get all the hours logged for that particular task, however I need to be able to filter out some hour types. Any idea on how can I achieve that? Looking at summing up just Task time and another type of time that we have in the system. A secondary issue i'm having is the calculation of Budget - % used. Although the values are identical in Budgeted and Actual Hours, calculation shows 60% instead of 100% (see screenshot) Thank you in advance. Have a great day! Silviu Partin
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Level 4
February 28, 2020
We have a calculated field for Budget % Complete with the following formula (this is a task level) DIV(Actual Hours,Planned Hours)*100 Jordan Martinson LeaseTeam, Inc.