Others

How to Fix Microsoft Project Custom Field Summary Totals Showing Zero

Elise Williams Oct 21, 2026 868 views

Question details

A Microsoft Project summary task is displaying a zero value for a custom currency field instead of the expected calculated total.

How to Fix Microsoft Project Custom Field Summary Totals Showing Zero

Product: Microsoft Project
Device & OS: not provided
Scenario: Viewing or calculating custom currency fields in task and group summary rows.
Observed behavior: The custom currency field shows a zero value in summary rows because the field is not actively configured to calculate or roll up values for those specific rows.

Before you start

Verify that your subtasks contain the actual currency data needed for the calculation and ensure that your base formulas are free of syntax errors.

Solution 1Recommended

Enable Formula Calculation for Summary Rows

Change the custom field settings to actively use a formula for task and group summary rows so that totals calculate correctly.

By default, Microsoft Project does not automatically apply custom field formulas to summary tasks. You must explicitly instruct the software to calculate these summary rows using your specified formula or rollup method.

Open Custom Fields

Navigate to the 'Project' tab on the top ribbon and click on 'Custom Fields' in the Properties group.

Select the Custom Field

In the Custom Fields dialog box, locate and select the specific custom currency field that is currently showing a zero total.

Adjust Calculation Settings

Look for the section labeled 'Calculation for task and group summary rows' and select the 'Use formula' option.

Apply and Refresh

Click 'OK' to apply the changes. If the summary values do not update immediately on your screen, save your project file, close it, and then reopen it to force a full recalculation.

Enable Formula Calculation for Summary Rows

Force Recalculation: If reopening the file is inconvenient, you can also try pressing F9 on your keyboard to manually trigger a calculation refresh across the entire project.

Free Microsoft Office alternative

Manage Project Data Easily with WPS Office

While Microsoft Project handles complex scheduling, managing project budgets, task lists, and custom calculations can often be done more intuitively in spreadsheets. WPS Office provides a lightweight, highly compatible alternative to Microsoft Office, complete with advanced spreadsheet capabilities for project tracking.

1. Download and Install: Get WPS Office from the official website and install it on your device in minutes.
2. Open Project Templates: Launch WPS Spreadsheet and browse the extensive template library for Gantt charts and project budget trackers.
3. Manage Custom Data: Use standard spreadsheet formulas to effortlessly calculate task summaries, costs, and rollups without complex configuration.

Fully compatible with Microsoft Excel (.xlsx) formats for seamless project data sharing and budget tracking.Easily calculate custom task totals, currency fields, and summaries using familiar spreadsheet formulas.Free and lightweight office suite including Writer, Spreadsheet, Presentation, and PDF tools.Rich library of free project management and Gantt chart templates ready for immediate use.

microsoft office alternative - wps office

Frequently Asked Questions

Why are my summary tasks not rolling up in Microsoft Project?

Summary tasks may not roll up automatically if the custom field calculation is set to 'None' for summary rows. You must explicitly configure the field to 'Rollup' or 'Use formula' in the Custom Fields dialog.

How do I force Microsoft Project to recalculate fields?

You can press F9 on your keyboard to calculate the project manually. If custom field summaries still do not update, saving, closing, and reopening the project file usually resolves the refresh issue.

What is the difference between Rollup and Use Formula for summary rows?

The 'Rollup' option mathematically aggregates the data directly from the subtasks (e.g., sum, average, maximum). In contrast, 'Use Formula' applies your specified custom formula directly to the summary row itself, independently of the underlying subtask values.

Can I use rollups for custom text fields in MS Project?

No, rollups are typically reserved for numeric, cost, or duration fields. Text fields cannot be mathematically rolled up, although you can sometimes use graphical indicators based on specific text formulas.

Office Quick Solutions