Hi, If you don't like my answer, please repost your question because a lot
of the times, people won't add additional answers if they see there are 2
posts on the question...
Okay, I was never a fan of % anything. It never calculates the way you
expect it to. I assume your plan is just using % to update tasks... Use
"Work" instead. But you don't use 'Work". It's okay, this will work all the
time on tasks and summary tasks...
All tasks have a "Duration" which automatically adds "Work" at maximum;
meaning, let's say you have a task that's 5days - that translates to 40hours.
As "Actual Work" goes up, "Remaining Work" goes down. When "Actual Work" =
40h, % Work Complete = 100%...
So, instead of using the % figures to calcluate your red/yellow/green, use
"Work", and "Remaining Work" and "Actual Work" in your formula... You will
always get that calculation to work correctly.
Hope that helps...
PM, MSPS, Network Consultant