Forum Discussion
MS Project (Desktop) - Total % Complete of all Total Number of Active Tasks under a Summary Task
- 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
I'm glad I understood and helped you.
The list separator symbol, usually ";" or "," depends, as you point out, on the regional configuration in the software or application being used, and can be configured by the user according to their preferences in Control Panel > Windows Region.
In many countries, such as the United States or Mexico, the comma is used as a list separator. In other places, such as in several European countries, Spain in my case, or in most Latin American countries, the semicolon is used as a list separator.
I have also observed that sometimes it is the operating system itself that automatically changes it to the user's region.
Therefore, the formulas must be entered with the separator symbol "comma" or "semicolon" depending on each country.
Regards.
Ignacio
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?
- Hello
Can you confirm that the automatic calculation option is set to On, in File > Options > Schedule > Calculation > Calculate project after each edit?
Ignacio
