Skip to main content

Overview

The Compare Projects report matches resource assignments between two projects and displays their costs side by side. Each row shows the cost from Project 1, the cost from Project 2, and the calculated difference, grouped hierarchically by WBS and work package down to the individual resource assignment level. Use this report to benchmark a new project estimate against a completed project, compare a baseline against a revised estimate, or analyze cost differences across related projects.

Prerequisites

  • Select two projects using the project filter bars. The grid does not load until both are selected.

Reading the Grid

The grid is organized hierarchically:
WBS
  └── Work Package
        └── Resource Assignment (Resource Code / Cost Class)
Each row shows three values:
ColumnDescription
Project 1Cost from the first selected project
Project 2Cost from the second selected project
DifferenceProject 2 minus Project 1. Negative = Project 2 is lower cost.
Expand WBS and work package rows to drill down to the resource assignment level.

Time-Phased Drill-Down

Click the View button on any row to open a pivot grid that shows the same cost comparison broken down to the time-phase level — fiscal year, quarter, and month side by side for both projects. Use this to understand when in the project timeline costs diverge.

Available Filters

FilterWhat It Controls
Project 1The first project to include in the comparison
Project 2The second project to compare against
Currency DivisorDisplay values in base dollars, thousands (K), or millions (M)

Exporting

Click Export to download the full comparison grid to Excel.

Saved Views

Compare Projects supports named saved views that preserve your column layout, grouping, and filter settings. Use the view selector in the toolbar to save and reload your own named views. Compare Projects