I am seeing what may be a bug but perhaps another set of eyes can help here.
I have a task which has 2 children. Those 2 children each have children of their own (grandchildren).
The Children are showing the correct % complete rolled up from the Grandchildren. However the parent is not.
It is my understanding that the formula used to calcualte % complete is:
% Complete is based on sum(duration of individual tasks * % complete of indivual tasks) / sum(duration of individual tasks)
I have verified this works. However, On the top level parent row it does not. I can't figure this out!
In the screen shot below, you will see the task name, duration, % complete, and then 2 custom columns I created for testing. The first is "True % Complete". This is using the formula above on each line and parent line. The second is "Working days" which is used to get the true duration of the parent tasks. Since in this example you will notice that the duration of the "Execute Cutover" task is 7.25d even though the tasks are only 5 hours total. This is due to a gap in time between tasks.
You will see that the True % Complete matches the % Complete in every Row except the top row ("Cutover"). I have done the math several ways and it seems that the % Complete should be rolling up to 57% not 41%. What is going on here?
Thanks for the help.
