Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

How do reports roll up data via Project Metrics vs Task Metrics? For example, the Project Status report calculates amounts based on whether project metrics by project or project metrics by task is used.

Solution

When the Report report criteria of “use the task budgets for project metrics” is utilized, the system collects actuals and estimates % complete, then derives Estimated Total for each task. The system will then add up the results of each task’s calculations to come up with the project’s totals.

...

  1. Task 1 - 50% completed, with budget of $100, and actuals of $50, and estimated total of $100. 
  2. Task 2 - 100% completed, with budget of $50, and actuals of $100, and estimated total of $100 (as the estimated total cannot be less than already incurred actuals).
  3. The sum of estimated totals for the 2 tasks is $200.
  4. Project with total budget of $150 and total actuals of $150.  The % complete Complete for this project will be calculated as all actuals over project’s budget: 150/150 = 100%.  The Estimated Total for the project is still $150.

Additional Information

Help Docs - Report Calculations

...