Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

Actual hours - custom calculation

Avatar

Level 2
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
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 4
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.