Total % Complete of all Total Number of Active Tasks under a Summary Task
1 TopicMS 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 tasks. If say three of those tasks were 100% complete (So 3/10 complete), the Summary Task would indicate 30% Complete. Essentially, the formula is looking at the total number of sub tasks under a Summary Task, checking the % Complete Field for 100%, if a task is 100%, then add 1, add up all the "1's", then task the Total number of Active Tasks, do the calculation to establish what % of the total number of Active Tasks are complete and thereafter, display the final % Complete. I'm not sure if the formula can only apply to Summary Tasks or not, but if not, the formula establishes whether or not it's looking at a Summary Task or a Sub Task, if a Sub Task, then ignore and leave blank for instance. I would like to ensure it is looking at the total amount of Active Tasks as there are cases where a bunch of tasks were setup and baselined, but there are delays that were not part of the original plan, thus a new task is entered between two tasks to show the effects of that delay, so Active Tasks within the formula is crucial. The reason for this formula is to be able to add this Custom Field to my Baseline Cost Report to indicate the production levels and establish how far behind our project team currently is in each different month. All other % fields are based on duration. I may require some advice on how to accurately display this Production level % in the Excel report as well. Any assistance and/or advice would be greatly appreciated. I have using MS Project for about 6 months, if I have missed something, please feel free to show me my mistake, this would certainly allow me to learn and gain a much better understanding of MSP.Solved3.9KViews1like14Comments
