I need to calculate the Planned % Complete to measure that variance between the actual and the planned on the summary level and not the task level.
I found an enterprise field (as I am using EPM - enterprise project server with Microsoft Project 2010) called "Planned % Complete" that calculates that for me. The field was working fine at the beginning: I baselined the project and was able to calculate the delays by using the difference between %Complete and the Planned%Complete.
When I did the next project update a month later, after I baselined the project again (using baseline1), the values seems completely wrong. for example a summary task shows 82% complete when all activities scheduled to start during the period is 100% complete. I changed a bit in the project to test if the field changes (by moving an uncompleted task earlier than the current date with say 10% complete) but no changes to the field.
Am I wrong to assume that Planned %Complete should not relay on the baseline as we should be able to calculate it based on the original start/finish and the %complete only. I saw a formula in one thread that relays on baseline that didn't make sense to me.
If anyone knows the formula, I'd appreciate it as I used weighted average to roll-it up on the summary level but the values seem off.