PlanAcademy - Learn Oracle Primavera

Plan Academy

  • About Plan Academy
  • Courses
  • Training for Teams
  • Blog
  • Video Channel
  • Contact
  • Login
PlanAcademy - Learn Oracle Primavera

Project Controls Training & Courses

  • About
    • Who We Are
    • Testimonials
    • Join The Team
    • Contact Us
  • Courses
    • All Courses
    • Course Bundles
    • Primavera P6 Professional
    • Construction Planning & Scheduling
    • Advanced P6 Schedule Building
    • Advanced P6 Progressing
    • Forensic Schedule Delay Analysis
    • Analyze P6 Schedules with ScheduleReader
  • Solutions For
    • Companies
    • Individuals
  • Case Studies
  • Resources
    • Blog
    • Video Channel
    • Webinars
    • Guides & Templates
    • Knowledgebase
  • Partnerships
    • ALICE Technologies
    • Deltek Acumen
  • Login
Blog > Guides > Duration Percent Complete in Primavera P6 – the Missing Guide

Duration Percent Complete in Primavera P6 – the Missing Guide

September 21, 2022 By Nader Khorrami Rad 48 Comments

  Share on Facebook   Share on Twitter
Duration Percent Complete in Primavera P6

There are many different methods for calculation of actual progress in Primavera P6.  These methods involve using many fields and settings, including:

  • Duration % Complete
  • Units % Complete
  • Physical % Complete
  • Activity % Complete
  • Performance % Complete
  • Percent Complete Type
  • Earned Value settings of the WBS Elements

I will explain Duration % Complete in this article. Other fields and settings will be explained in future articles and we will finally have a complete picture of the whole actual progressing system in Primavera P6.

Primavera P6’s 3 Types of Activity Percent Complete

Each activity has three percent complete fields that are calculated all the time:

  1. Duration % Complete
  2. Units % Complete
  3. Physical % Complete

Only one of these values will be selected by the user as the activity’s progress, even though all of them are calculated all the time. I will explain how to choose the appropriate activity percent complete in future articles.

Duration % Complete Calculations

The most common problem with Duration % Complete is that Primavera P6 uses a counterintuitive formula. You may expect it to be something like Microsoft Project’s formula:

Duration % Complete(MS Project) = [Actual Duration] / ( [Actual Duration] + [Remaining Duration] )

But this is not the P6 formula. Duration % Complete is calculated with this formula:

Duration % Complete(P6) = ( [Original Duration] – [Remaining Duration] ) / [Original Duration]

This formula uses Original Duration, which may be different from the current duration. We will check this on the following sample.

Sample: We have an activity with original duration of 20 days. 15 days have passed and we estimate it to finish in 18 days (yes, it’s much longer than we expected initially).  The Original Duration does not change automatically after activity’s start.

Original Duration: 20d
Actual Duration: 15d
Remaining Duration: 18d

[Duration % Complete] = (20-18)/20 = 10%

Intuitive or MSP-like Duration % Complete = 15/(15+18) = 45.45%

The following figure shows the initial state of this sample activity (named A1):

Learn Primavera P6 Duration Percent Complete

Let’s say that the activity has started in May 8th. We’ll check the Started checkbox and enter the actual start date in its date box.

Learn Primavera P6 Duration Percent Complete

Learn Primavera P6 Duration Percent Complete

Suppose that it’s currently May 27th; we will reschedule the plan for this data date.

Learn Primavera P6 Duration Percent Complete
The Actual Duration is automatically calculated based on Actual Start Date and the Data Date, as follows:

[Actual Duration] = [Data Date] – [Actual Start] (P6 formula for in-progress activities)

Unfortunately, you cannot change the Actual Duration field manually.

Now we can enter the remaining duration. In this example, we estimate that A1 requires 18 more days to be completed.  We’ll enter 18d in remaining duration field.  By entering a remaining duration, Duration % Complete will be calculated automatically.

Learn Primavera P6 Duration Percent Complete
In this case, Duration % Complete is calculated as 10%.

We could have entered the Duration % Complete instead of the Remaining Duration and P6 would have calculated Remaining Duration automatically .
Now, take a look at the Gantt chart.

Learn Primavera P6 Duration Percent Complete

When you look at the Gantt chart, you see that about half of the current duration is actualized and you may expect a Duration % Complete of around 50%. The exact number of the intuitive formula is 45.45% in this example, which is not equal to our Duration % Complete.

Changing the Original Duration

Primavera P6 uses the following equation for Original Duration is used when an activity is not yet started:

[Original Duration] = [Early Finish] – [Early Start]

However, after the activity has started, Original Duration will not be automatically calculated by Early Start and Early Finish, and you can change it manually.  The At Completion Duration represents our current duration, calculated as:

[At Completion Duration] = [Actual Duration] + [Remaining Duration]

In our example, the At Completion Duration is calculated to be 33d.  We will enter the same value for the Original Duration field and this would be the result:

Learn Primavera P6 Duration Percent Complete

The activity’s schedule is not changed, but Duration % Complete is recalculated based on the new Original Duration; and yes, it’s the intuitive value that we calculated before.
When Original Duration is equal to the At Completion Duration, the Duration % Complete will have the intuitive value. The following equations show how the P6 formula would become the intuitive formula, when the Original Duration is equal to the At Completion Duration:

[Duration % Complete]* = ( [Original Duration] – [Remaining Duration] ) / [Original Duration]

= ( [At Completion Duration] – [Remaining Duration] ) / [At Completion Duration]

= [Actual Duration] / ( [Actual Duration] + [Remaining Duration] )
* this equation is based on the assumption that Original Duration is equal to the At Completion Duration.

If you would like to have the intuitive Duration % Complete (for any reason), you can create a global change to set the Original Durations of in-progress activities. The following figure shows the appropriate global change setup.

Learn Primavera P6 Duration Percent Complete

This global change checks each activity’s status; if it’s “In Progress”, then the At Completion Duration would be copied to the Original Duration.  We will then have the intuitive Duration % Completes for all activities.

Duration % Complete for WBS Elements

The previous explanation was focused on Duration % Complete for Activities.  Duration % Complete is also calculated for WBS Elements, but I strongly recommend you not to use Duration % Complete to track a WBS Element’s progress.  Thus I have not included an explanation of the calculations here.

You should always think of Duration % Complete as an intermediate field and use Performance % Complete to track activities and WBS Element’s actual progresses.

I will explain the calculation and usage of Performance % Complete in a future tutorial.

Summary

This tutorial has demonstrated the internal calculations of Primavera P6’s Duration Percent Complete field.

The most common problem in this area is that Primavera P6 does not use the intuitive formula for Duration % Complete which confuses some planners and project managers. We explained the Primavera P6 calculations and the intuitive formula side by side, to show the differences and create a better understanding of the P6 method. Finally, if you absolutely need to use the intuitive formula, try the Global Change described above.

Remember, Duration % Complete does not provide a final result; it is used in a system which provides the actual progress. You should use Performance % Complete to read the actual progresses.  We’ll cover that in an upcoming tutorial soon.

New Call-to-action

Filed Under: Guides, Progressing Tagged With: % Complete

About Nader Khorrami Rad

Nader Khorrami Rad is a project planning and control expert with 12 years of experience in different industries and certified as PMP (Project Management Professional), CSM (Certified ScrumMaster) and PSM I (Professional ScrumMaster). He is the author of 38 books in Persian and 2 ebooks in English. Connect with him by visiting his website or on Twitter @KhorramiRad.

Comments

  1. ramkumar says:
    June 12, 2012 at 5:56 am

    i am very much great ful to you , i have a great experience with your subject,please guide the planners in the same manner so that the planning world shuold be the ruler in the universe.

    Please let us teach about resources also

    Reply
  2. s.a. mallick says:
    July 04, 2012 at 2:08 am

    Your Comments
    The above mention information is really very useful . Is it possible to give information for physical percnt complete method also and also about cost loading in detail considering i am very new in planning job
    Thanks and Regards
    s.a.mallick

    Reply
    • Nader Khorrami Rad says:
      July 05, 2012 at 3:17 am

      I’m happy that you’ve found it useful.
      The Physical % Complete will be covered in the next article, which will be published in near future.

      Reply
  3. Behzad says:
    July 22, 2012 at 7:01 am

    I Really thank you. and i am stronglywaiting for Performance % Complete article.

    Reply
  4. Arun R says:
    August 20, 2012 at 2:14 pm

    Dear Mr.Nader,
    I can’t say what i feel reading your article. It’s very helpful & is mentioned so simply. I like that. I am waiting for Performance % Complete article. Plannertuts is one of the best websites I seen which publishes great helpful article. I waiting for more article that help me to grow.

    Reply
    • Nader Khorrami Rad says:
      August 20, 2012 at 2:48 pm

      You’re welcome Arun; I’m glad that you’ve found it helpful.

      Reply
  5. Mohamed Khafagi says:
    September 13, 2012 at 8:01 pm

    I have problem in P6 that the performance % is equal zero , even the activity percentage changed with values , what could be the cause , even I reviewed the admin prefrences & check activity % with the performance % technique.mments

    Reply
    • Nader Khorrami Rad says:
      September 22, 2012 at 7:23 am

      Dear Mohammad,
      The most likely problem is that you did not define any costs for activities. The calculation of Performance % Complete is depended on them.

      Reply
  6. Shuvro says:
    February 27, 2013 at 1:07 am

    Dear Sir,

    Great Post !

    Can you please enlighten about DURATION % OF ORIGINAL. how is it calculated (Formula) and how is it different from Dur % Complete. and When it should be used?.

    Regards

    Shuvro.

    Reply
  7. Nader Khorrami Rad says:
    March 11, 2013 at 6:23 am

    Dear Shuvro, it’s simply [ (actual duration) / (original duration) ], and it’s not used in other calculations that I’m aware of. And yes, it can go higher than 100%.

    Reply
  8. hosna says:
    March 12, 2013 at 3:49 am

    Hi
    I have some problem with my P6 i was wondering if you could help me with that
    In activities detail i want to set details but it is inactive so what can i do? What can cause this Mather?
    Bests
    Hosna

    Reply
    • PlannerTuts says:
      March 12, 2013 at 8:53 pm

      Hosna, the Activity Details sometimes goes gray if you have multiple activities highlighted or if you are a highlighting a WBS or group bar. If this doesn’t solve it, reply back with more info.
      PT

      Reply
  9. nafis says:
    April 16, 2013 at 4:41 am

    Hi

    I find this site recently, I could solve some of my problems by this site,
    thanks alot

    Reply
  10. viju says:
    May 06, 2013 at 12:15 pm

    We have observed the following – For some activities, when the activities are complete, the at completion goes to zero, but for some the at completion shows the real cost. Why?

    Reply
  11. David Hutchinson says:
    May 29, 2013 at 2:50 pm

    Nader… we have noticed that there are times when ‘actual duration’ + ‘remaining duration’ do not equal at ‘complete duration’. It appears that this can be caused when a predecessor’s early finish date is overridden with actual start and finish dates. Comments?

    Reply
  12. manoj says:
    June 22, 2013 at 10:35 am

    Sir, let me know how to calculate the planned % from my schedule. Our physical progress is 86.4%.Target completion date is September data date is 13-6-13

    Reply
    • Kriss says:
      February 02, 2016 at 7:48 am

      In a cost loaded schedule, go to Columns and Expand the option Percent Completes where you can find “Schedule % Complete”. Add this filed to your Columns. This will give the Planned %.

      Reply
  13. Chris R says:
    June 28, 2013 at 9:24 am

    Why does P6 calculate Duration % Complete with the formula mentioned above? If you change your original duration, to match your at complete duration, how will you ever get P6 to give you an SPI value other than 1.00?

    Reply
  14. Blythe Engineer says:
    July 19, 2013 at 2:11 pm

    Hi,
    In our project progress, my project finish date is passing the required finish date. Is there any way that I can assign a constraint and remaining activity durations get smaller to hit the target finish date? For example, my project finishes on 14-Jan-2014, but I want to finish it on 28-Nov-2014. What should I set my activity type and duration type and percent complete type for Primavera to auto shorten the remaining durations but keeping the same budgeted labor units. I sincerely appreciate any help.

    Reply
  15. Jae Lee says:
    July 31, 2013 at 5:43 pm

    How can I say what you have accomplished in this articles…This is the greast single challenge never seen before in PM/CM area. I am certain that your reputation and contribution will be long remembered and will impact thousands of Primavera admirers, leading you to great sucess in your profession.

    Reply
  16. cris benecio says:
    August 06, 2013 at 6:14 am

    Any article of Performance % Complete? I’m waiting for it…

    Reply
  17. Michael Lepage says:
    August 06, 2013 at 8:57 pm

    @cris – sorry it’s only available on our premium site.

    Reply
  18. Mamoun says:
    September 08, 2013 at 4:32 am

    Dear Sir
    i have a problem and i can’t understand this case
    in my project Duration % Complete is 71.76 %
    & Performance % Complete is 100 %

    what’s mean please ??

    BR

    Reply
    • Muhammad Zahid Iqbal says:
      September 21, 2014 at 7:45 am

      performance percentage is linked with physical percentage so you have to put it manually. 100 percent means your activity is actually finished but as planned its not finished. Reason is that an activity might have actually started earlier than planned date

      Reply
      • PlannerTuts says:
        September 24, 2014 at 2:25 pm

        Is this helpful? https://www.planacademy.com/primavera-p6-relationship-lines-baseline-bars/

        Reply
  19. Mohammed Faizal says:
    September 23, 2013 at 12:02 pm

    Dear Nader,

    found your article helpful, but wonder why some quest arises in mind that

    Scenario
    1. OD= 10
    2. AD= 10
    3. RD= 10
    3. % Compl= 0%
    but still some quantity of work progressed and duration lapsed and resource did some work. could u please explain.

    Reply
  20. Abdulhafiz S says:
    September 27, 2013 at 5:58 pm

    Mohammed F…,

    The scenario you described is perfectly valid, especially if your %complete type is set to Duration.

    This kind of scenario will occur when your work is not evenly distributed with time.

    I would suggest that you use physical % complete type for tasks like construction activities whose progress is often not distributed evenly over the duration.

    However if you feel duration % complete is right for you, you might want to fiddle with your Original duration or your Remaining duration.

    This is as far as i understand.

    Regards

    Reply
  21. Mike Kenny says:
    November 03, 2013 at 9:47 am

    Your tutorials are really useful , but are you able to answer a problem I have.
    I’m using P6 r8.0. My Activities are DURATION PC and FIXED DURATION / UNITS. They are being planned with EXPECTED FINISH and CONSTRAINT dates. Whilst I understand that the schedule will update the REMAINING DURATION (using EXPECTED DATE – DATA DATE) … why would the Schedule process set my PLANNED (Original) DURATION and UNITS to ZERO?

    Reply
  22. Alexander says:
    November 15, 2013 at 2:00 am

    Thank you for helpful article.
    Where I can find the next topics about Duration complete?

    Good luck.

    Reply
  23. Aamer says:
    April 11, 2014 at 1:02 pm

    Could any one PLEASE tell me how
    how does the factors below affects an activity’s Performance
    in short how do we decide what duration type to select for an activity ?

    1.Fix Duration &Units
    2.Fix Duration &Units/time
    3.Fix units
    4.Fix Units/time

    Then what percentage type you usually adopt.
    1.Duration
    2.Physical
    3.Unit.
    I am very confused with all these- perhaps, a calculator/pen/paper would be the best option
    kind regards
    Aamer

    Reply
    • Michael Lepage says:
      April 28, 2014 at 2:22 pm

      Aamer,
      For Duration Type, stick to Fixed Duration & Units/Time – only change this if you’re trying to have P6 calculate durations or number of resources (in very special circumstances – like a change request or scenario).
      Most industries use Physical % Complete. Units is never used, and Duration is the default but not ideal – stick to Physical. I teach both of these subjects in great detail on PlannerTuts Premium – our online training portal.
      Michael

      Reply
  24. Aria says:
    May 07, 2014 at 11:49 pm

    I think “Suppose that it’s currently May 29th”; is correct . would you check again?

    Reply
  25. SUNIL says:
    December 16, 2014 at 2:09 am

    Please tell me how I can reschedule/update a project with out affecting the end date of the project.

    Normally when I update a project, the end date/completion date keeps on moving forward. I want to keep the end date fixed so that I can rearrange my resources accordingly.

    Reply
  26. Arul says:
    March 23, 2015 at 5:57 am

    when ll you post unit % and physical %

    Reply
  27. Afsaneh says:
    July 11, 2015 at 3:56 am

    hi
    can you explain, how calculate the original duration for activity that planned to starts on 7-may an finished on 1-July….it is equal to 25 not 20.am i right?

    Reply
  28. Amin says:
    September 21, 2015 at 2:37 pm

    Duration % Complete for WBS Elements
    how to calc wbs element ?

    Reply
  29. Emmy D. Onuoha says:
    March 23, 2016 at 3:39 am

    Duration % complete is a lazy man’s way progressing activities of a programme. NEVER to be used in a complex and multiple trades environments. Monitoring duration is does not help at all. My advice is to use Physical % complete. Project performanace is judged by physical work done NOT duration taken.

    Reply
    • de jong says:
      April 28, 2017 at 12:41 pm

      Emmy,

      Concerning the financial project performance:
      In many projects the clocked manhours are in a different software system , and primavera calculates the earned value hours. The calculation of the earned value is done by % complete times 1% of the baseline budget.
      This means that it does not matter what kind of % kpl you use.

      Physical % complete has also problems of its own ,regarding the end date of a project.

      As % complete and the rest duration are not connected , an activity of for instance 10 days can be given 90% complete with a rest duration of 8 days.This implicates that a project with a duration of for instance 12 months can be reported 80% complete with a rest duration of 10 months. Nice when there is a fixed end date of a project and you report to the management that they are 80% complete.

      Anyway, working with a PDM network, the time schedule is driving by duration and not by manhours.

      Reply
  30. Rory says:
    October 28, 2018 at 5:37 pm

    If you use a global change to change the original duration then you are changing the durations that you planned therefore your as built schedule will not be useful for estimating durations on future similar projects. Therefore you will not able to review your planned durations (original duration) against your actual durations. Using your global change methosshould not be recommended in my opinion.

    Reply
  31. Faysal Farhat says:
    October 22, 2019 at 5:46 am

    why primavera p6 does not take more than 2 decimals for performance % completion?
    how can i make it to take more than 5 decimals

    Reply
    • Michael Lepage says:
      October 24, 2019 at 3:45 pm

      Sorry, P6 only has the option for 1 or 2 decimals. There’s always Excel.

      Reply
  32. Jessica Flare says:
    November 30, 2019 at 2:57 am

    waiting for your other articles: Activity % Complete, Performance % Complete

    Reply
  33. Amr Salah says:
    September 06, 2020 at 5:50 am

    why the performance % complete for WBS is zero Although it equals the activity % for every task

    Reply
    • Michael Lepage says:
      September 17, 2020 at 2:18 pm

      The Performance % Complete of the WBS element will be calculated by [Performance % Complete] = EV / BAC formula. It’s not the sum of the underlying activities. Check EV & BAC for the WBS element.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

book a demo

Popular Articles

  • Primavera P6 Version 20.12 Is Out. Here’s What’s New.
  • Critical Path vs Longest Path
  • Graphing a P6 Resource S-Curve in Excel
  • How To Help Your Project Controls Team Love Online Learning
  • 11 Killer Interview Questions For Hiring A Project Controller
  • 7 Earned Value Management Formulas To Make Your Life Easier As A Project Controls Professional
  • How to Audit Your Primavera P6 Global Activity Codes
  • Boring Project Reports? 8 Project Timeline Tools To Help You Create Visual Reports
Browse All Article Topics

Company

  • About Plan Academy
  • Case Studies
  • Join The Team
see our reviews on g2crowd



We accept the following:

Training & Support

  • Courses
  • Training for Teams
  • Free Webinars
  • Free Resources
  • Blog
  • Help Center

Legal Stuff

  • Terms & Conditions
  • Privacy

Connect

Contact Us

Customer Support

Plan Academy Inc.
Hamilton, ON Canada.

1-877-626-2690

Follow Us:

Copyright © 2023 Plan Academy Inc. · All Rights Reserved ·