Planned Versus Actual Completion

[abw1987]

Hello!

New member here. First I want to apologize for being your typical "I expect help on my first post" user. I used to be a member of another office forum that I'm having trouble finding. (Maybe it's gone.) I would really appreciate any help, and I'll do my best to "pay it forward" in this forum.





Here is what I am trying to accomplish. I would like to compare planned versus actual completion. I want one column that calculates planned completion as a percentage that changes based on the project Status Date, and a second column that allows the user to manually enter actual completion percentages.

The first column would easily be accomplished using the standard % Complete field. Changing the project status date causes the values in this field to update automatically. Perfect.

The second column, however, seems to be a bit trickier. My initial thought was to use a Text field. The problem with this approach is that the percentages don't roll up to the summary task levels. And of course, if it did roll up, I wouldn't want it to just be an average of all the percentages within the task grouping. For instance, if Task A is five days long and marked 100%, and Task b is ten days long and marked 0%, the parent task completion shouldn't just be 50%. It should be 33%. So in short, I would like the roll-ups to be evaluated in a similar manner to the standard % Complete field, but I want to be able to manually enter the percentages for each task.

Do you know of any way to accomplish this? I am open to many ideas.

Any help would be much appreciated. Thanks!