Adel,
First, the hints from others to look at things like baselines and the earned
value are good. My assumption is that the Percent Complete field is not
working for you and that you are looking for something simple.
The following method is not simple to set up, but it makes entering the data
very simple.
Since you are not entering costs or resource assignments, I assume you are
entering a duration (your planned value) and either a % complete or an Actual
Duration to provide the status. The summary "% Complete" field calculates
based on [Actual Duration]/[Duration]*100. When you enter the Percent
complete at the task level this rolls up. Since this number is not what you
expect or desire, I assume that your planned completion is not really based
on the actual duration but instead based on some other criteria.
If the "% Complete" is a value that does not correlate to the duration (for
example after 2 days of a 5 day task you are 73% done with the task), then
the "Physical % Complete" may be used to capture this. But unfortunately the
"Physical % Complete" field does not roll up to the summary levels. But you
can use custom fields with formulas to summarize the percent complete based
on the physical percent complete at the summary or project levels.
An example of formulas that work, but are not necessarily elegant are shown
below. The fields I used first convert the durations to numeric values, roll
these up to the summary levels and then use a formula to calculate the the
physical percent complete at the Summary and Project levels. The third field
is the only one you need to display as it contains the value I think you may
be looking for. The name I gave the field, the Project custom field used, and
the formula for each are shown below.
Number of Days (Number 1): [Duration]/480
- This converts the task duration to an integer value assuming you have a
standard 8 hour day. This value can then be rolled up using the Sum roll-up
option when defining the field.
Portion Completed (Number 2): ([Duration]*[Physical % Complete])/48000
- This uses the entered value for Physical % Complete you enter at the task
level to calculate the portion of the duration that has been completed in a
format that can be rolled up. Again the roll-up for this custom field must be
defined as Sum.
Physical Percent Complete Summary (Number 3): [Number2]/[Number1]*100
- This calculates a new percent complete that is the same as the Physical
Percent complete at the task level. Setting the roll-up for this field as
"Formula" will then give you the desired percent complete at the summary or
project level.
If you add the Physical Percent Complete and the last field we created,
Physical Percent Complete Summary, to a task view, and then enter a task
level Physical Percent complete you will see that it is summarized in a
logical way.
Hope this helps,
Jim P
