Forum Discussion
Mike_Murphy365
Mar 23, 2022Copper Contributor
MS Project % Complete Calculations Derived from Actual Work (Costs) Completed and EAC?
Does Microsoft Project have an option (especially one that can be defaulted to) to calculate % complete based on actuals divided by EAC for a given task (which could then also be rolled up to higher ...
- Mar 23, 2022Mike_Murphy365,
Simple answer, no. That said, a custom field can be created with a formula to calculate actuals (need to define exactly what that means to you) divided by EAC. If you want that new calculated value to actually appear in the % Complete field, that can also be done with some VBA.
Hope this helps.
John
Mike_Murphy365
Mar 23, 2022Copper Contributor
John-project Excellent, thank you! It would ne nice if this was something hardwired in as an option since I have seen a trend in this "angle-of-attack", especially when objective completion / % criteria are a challenge. Thanks again.
John-project
Mar 23, 2022Silver Contributor
Mike,
You're welcome and thanks for the feedback. I suggest you submit a request through Project's Feedback portal found at the bottom of the Project splash screen.
John
You're welcome and thanks for the feedback. I suggest you submit a request through Project's Feedback portal found at the bottom of the Project splash screen.
John