none
Tasks % completion - Re-categorize RRS feed

  • Question

  • Hello,

    I have completed a planning with multiple tasks and substasks with their individual duration.  I use the %completion feature to evaluate the %complete of every groups and entire projects.  My MSProject is divided in respect with the different areas of the project, but I will need to complete a report every month with %complete with respect with the subtasks.  

    Example : 

    Actual project file : 

    Summary Area A
     - Summary general task A1
        - Task A1.1
        - Task A1.2
    - Summary general task A2
        - Task A2.1
        - Task A2.2

    Summary Area B
    -  Summary general task B1
        - Task B1.1
        - Task B1.2
    - Summary general task B2
        - Task B2.1
        - Task B2.2

    Results that I need for my report : 

    % completion(in fonction of the entire project) of Task A1.1 + task B1.1 

    % completion(in fonction of the entire project) of Task A1.2 +task B1.2 

    etc.

    Since it is a job that I will have do for many repetitions, I would like to be able to program something that calculates by itself.

    Thanks for your help,

    Mathieu

    Thursday, February 25, 2016 4:36 PM

All replies

  • Hello,

    I'm pretty sure the Grouping feature will help you, but to be more concrete I have to ask you what is

    "%completion in function of the entire project"

    Can you give e formule that would calculate that?

    Greetings,

    Thursday, February 25, 2016 7:27 PM
    Moderator
  • Hello,

    I would suggest to do the following:

    1) create a custom field (Text1) with a lookup for the grouping:

    

    2) Assign to each task the custom field value

    3) Create a new Group by option under View Tab

    the result will be to have the % Competete of each grouping:

    Wednesday, March 2, 2016 1:16 AM
  • Hallo,

    Exact of course but I keep wondering what is "% completion(in fonction of the entire project)"

    MS Project's %Complete is unrelated to the entire project.

    Greetings,

    Wednesday, March 2, 2016 2:18 PM
    Moderator