Forum Discussion
Solved
MS Project (Desktop) - Total % Complete of all Total Number of Active Tasks under a Summary Task
I am looking for what I believe is a complex formula. What I am looking to achieve is the following (Example), this would be a new Custom Field: I have a Summary Task with say 10 active sub t...
- To those who may be following this thread:
The "answer" to the calculation question is addressed in my response to this same question on the Microsoft Answers forum at:
https://answers.microsoft.com/en-us/msoffice/forum/all/why-does-ms-project-not-calculate-upon-opening/8508dd45-b74d-4319-8301-7167d2858079
John
Hello
You can try the following...
Insert two custom numeric fields and one text field into your task list and enter the formulas and configuration of each field, as shown in the images below, through: Menu > Project > Properties > Custom Fields.
Number1 counts the total number of active subtasks, using the formula (copy and paste): IIf([Active];1;0)
Number2 counts the total number of subtasks completed 100%, using the formula (copy and paste): IIf([% Complete]=100;1;0)
Text1 calculates and rounds the percentage of tasks completed, adding the "%" symbol, only for summary tasks (copy and paste): IIf([Summary];round(100*[Number2]/[Number1]) & "%";"")
N.- If you want you can hide the Number1 and Number2 columns, and rename Text1.
I hope you find it useful.
Ignacio
Incredible,
I didn't imagine it would be possible to insert formulas into MSP, I'm learning more and more in this community, thank you very much for sharing all the knowledge.
I didn't imagine it would be possible to insert formulas into MSP, I'm learning more and more in this community, thank you very much for sharing all the knowledge.