How to calculate the percentage of actual task performance
To create the custom field for calculating the percentage of time a resource will work on a given task please follow the steps below:
- Set Estimated and Actual Time for tasks
![](../../images/tutorial/faq/how-calculate-percentage-actual-task-performance001.png)
2. Go to Tools/Custom fields and click “New” button
![](../../images/tutorial/faq/how-calculate-percentage-actual-task-performance003.png)
3. In 'Title' field enter the title for this custom field, for example, Actual/Estimated
![](../../images/tutorial/faq/how-calculate-percentage-actual-task-performance005.png)
4. In ‘Code’ field enter “cf_actual_estimated”
![](../../images/tutorial/faq/how-calculate-percentage-actual-task-performance007.png)
5. In “Type” field select 'Float'
![](../../images/tutorial/faq/how-calculate-percentage-actual-task-performance009.png)
6. In 'Formula' field enter the following formula and click “Ok”:
$actual_time/$estimated_time*100
![](../../images/tutorial/faq/how-calculate-percentage-actual-task-performance011.png)
For example, if you set Estimated Time 4 hours and Actual Time 3 hours for certain task, the percentage of time a resource worked on a given task will be calculated as 74.9 %
3 hours (Actual Time) / 4 hours (Estimated Time) = 74.9 %
![](../../images/tutorial/faq/how-calculate-percentage-actual-task-performance014.jpg)
|