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
Ignacio_Martin this worked great. Thanks for putting this up. One thing I had to change though... it threw a syntax error on the [Active] flag field. It didn't recognize it but when I changed it to [Flag1] it worked. My ver of MS Project apparently doesn't have an Active column so I used Flag1 in the formula and it works as you designed! Not sure why I didn't have Active but no matter, it's good now. Thanks again!
Certainly in the Standard desktop version, as well as in previous versions, the Active field is not available. Yes it is in the Professional version.
In any case you used a good alternative to the formula, and I am glad that the proposal was useful to you.
Ignacio
One follow up question, now that I've used it for a day. When I reopen the plan after it's been saved it has converted all my calculated task %'s into #ERROR. All I have to do is select Calculate Project and the errors disappear and show the correct % amounts. Any idea why it opens with errors?
harmonica_man290 → I experienced the same issue each time I reopened the project file. The way in which I fix this is to right-click on the filed and select Custom Fields. Then select the dropdown and select Number (If you are not there already). Then go into each custom number (Starting at 1) and select the Formula Button (To view the formula), then click on OK. Go through this for each of them. I can't remember exactly what formula needed this, but it resolves the ERROR. I hope this helps 🙂
- Hello
Can you confirm that the automatic calculation option is set to On, in File > Options > Schedule > Calculation > Calculate project after each edit?
Ignacio
