Forum Discussion
Linking Tasks to aggregate % complete
I have a group of 10 tasks , say group 1 tasks. These 10 tasks have a hierarchy among themselves. I have another group of 100 tasks, say group 2 tasks. These 100 tasks have a hierarchy among themse...
NKumar2010 --
If I understand your question correctly, I believe you are trying to calculate the % Complete values for selected groups of tasks. Here is something you might try:
1. Create a custom Text field named Task Group.
2. Add a lookup table to this custom field and include values like Group 1, Group 2, etc.
3. Insert this custom field in any Task view, such as the Gantt Chart view.
4. In the custom column, specify a value for each task, like Group 1, Group 2, etc.
5. To the right of the custom column, insert the % Complete column as well.
5. Click the AutoFilter pick list button in the column header of the custom column and then select the Group on this Field item on the pick list menu.
If you look at the % Complete column, you should see the aggregated % Complete value for each group of tasks. Just a thought. Hope this helps.
If I understand your question correctly, I believe you are trying to calculate the % Complete values for selected groups of tasks. Here is something you might try:
1. Create a custom Text field named Task Group.
2. Add a lookup table to this custom field and include values like Group 1, Group 2, etc.
3. Insert this custom field in any Task view, such as the Gantt Chart view.
4. In the custom column, specify a value for each task, like Group 1, Group 2, etc.
5. To the right of the custom column, insert the % Complete column as well.
5. Click the AutoFilter pick list button in the column header of the custom column and then select the Group on this Field item on the pick list menu.
If you look at the % Complete column, you should see the aggregated % Complete value for each group of tasks. Just a thought. Hope this helps.
Let me give it a shot. Please see my reply above to John's post to get some clarity. How do I do step 2 i.e. add a look up table to a custom field ?