Address Inaccuracies Published for Summary Values

If you see that hours are counted twice in reports that contain task hours, you can correct the problem with the procedure in this topic. The Progress dashboard and the Burndown and Burn Rate and Remaining Work reports may show double-counting of work hours.


When you use Microsoft Project to create parent and child tasks, it assigns parent tasks the rollup of hours that are defined for all its child tasks. Rollup hours are not published to Team Foundation so that the hours are not double-counted in certain reports. The Microsoft Project mapping file attribute, IfSummaryRefreshOnly, suppresses the publication to Team Foundation of the hours that are assigned to summary tasks. You can view the rollup of hours for summary tasks in Office Project but not in Team Foundation. For more information, see The Microsoft Project Field Mapping File.

When both summary tasks and their child tasks contain hours in the effort fields, you essentially have double-counting of the level of task effort. To address these inaccuracies, you must clear the Original Estimate (or Baseline Work for team projects that have been upgraded), Remaining Work, and Completed Work fields for the summary or parent tasks.

Required Permissions

To perform this procedure, you must be a member of the Contributors group or your View work items in this node and Edit work items in this node permissions must be set to Allow. For more information, see Team Foundation Server Permissions.

To clear the hour fields of parent or summary tasks

  1. In Team Explorer, expand the Work Items node for your team project, and locate the Work Items with Summary Values team query.

    This query is located either in the Team Queries folder or the Planning and Tracking folder under the Team Queries folder.

  2. Run the query.

  3. Select Collapse all (Collapse All) so that only parent or summary work items appear in the query results.

  4. Press CTRL-A to highlight the parent work items that are listed.

  5. Right-click the highlighted area, and then click Open in Office Excel Open in Microsoft Excel.


    Export the query results to Microsoft Excel with the rows collapsed. This condition exports only the parent or summary tasks.

  6. In the Microsoft Excel document, for the area and iteration paths that you are managing, clear the values in the following three columns:

    • Original Estimate

    • Remaining Work

    • Completed Work

  7. (Optional) Save the Microsoft Excel file. 


    The work items in this list are based on the work item IDs and not a work item query. To address inaccuracies that may occur later, you must repeat steps 1 through 6.

  8. On the Team tab, click Publish.

    For more information, see Publish Work Items in Office Excel.

  9. Wait an hour or more for the data warehouse to register the changes.

    The default refresh frequency for the data warehouse is one hour. For more information, see Change a Process Control Setting for the Data Warehouse or Analysis Services Cube.

  10. Verify that the changes have been picked up by viewing the Progress dashboard or other work report.

See Also


Progress Dashboard (Agile)

Burndown and Burn Rate Report (Agile)

Remaining Work Report

Customizing Microsoft Project Field Mappings

Scheduling Tasks and Assigning Resources Using Microsoft Project