Calculating Group and Summary Values

By default, Microsoft Project does not calculate values for custom fields for summary tasks or for the rows containing rolled-up values for groups. However, you can specify how to calculate a value for summary rows. To use the same formula that you defined for the custom field, select the Use Formula option under Calculation For Task And Group Summary Rows in the Customize Fields dialog box. If you select the Rollup option, you can choose from several simple calculations including the following:

Average. The average of all nonsummary values underneath the summary task or group. Average First Sublevel. The average of all the values of tasks one level below. Maximum. The largest value of all nonsummary values. Minimum. The smallest value for all nonsummary values.

Sum. The sum of all nonsummary values underneath the summary task or group.

When you work with a custom number field, the following calculations also appear when you select the Rollup option:

Count All. The number of summary and nonsummary tasks one level below the summary task or group.

Count First Sublevel. The number of nonsummary and summary tasks one level below the summary task or group.

Count Nonsummaries. The number of nonsummary tasks below the summary task or group.

Do the following to pick a mathematical function for a rollup value:

1 Select the Rollup option.

2 Click one of the functions in the Rollup list.

lO Cl

Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment