Cortex Budget Builder | Compare Budgets
Compare budgets
You can compare two or more budgets side-by-side in Cortex Budget Builder.
To compare budgets
- In the budget collection, select the check circle (first column) for each budget you want to compare. To select all the budgets in the list, click the check circle located next to the Budget name column heading.
- Click
(Compare budgets).
The selected budgets display side-by-side in a tabular layout with the budget attributes in the first column. If all the budgets contain 0 (zero) for a particular attribute, that attribute will not appear in the comparison.
Expand and collapse attribute groups on the Compare budgets page as needed to see the information you need.
How do I?
Select a baseline budget
- To select the budget, click the check circle located at the top of the project image.
- Click
. The selected budget moves to the first column.
As you scroll through the budget columns, the baseline budget remains visible in the first column.
To cancel the baseline budget selection, click
.
Tip
You can also select a baseline budget by dragging a budget from the comparison and dropping it at the baseline position (first column) in the comparison. The + symbol, baseline budget icon, and budget name appear as you drag the budget to the baseline position.
Likewise, to remove a baseline budget, you can drag and drop it on the other comparison columns.
Review attributes across budgets
Click the Attributes tab.
Expand and collapse groups as needed. To collapse all the groups, click
. To expand all the groups, click
.
Change the attributes for the comparison
- Click
(Settings), and then click Settings in the list. - On the Attribute rows tab, move attributes between the Selected list and Available list to select the desired compare attributes.
Change the attribute statistic columns
- Click
(Settings), and then click Settings in the list. - On the Attribute statistics tab, move statistic columns between the Selected list and Available list to select the desired statistic columns.
To reset the default column selections
Click Reset to default in the Configure Grid: More Compare Columns window or Configure Grid: Statistic Columns window, depending on which defaults you want to reset.
Ignore zeros tip
The Ignore zeros check circle determines whether the statistics include or exclude budgets that contain zeros. If a budget in your comparison contains a zero and is not applicable to your scenario (e.g., you are trying to obtain an average of all the budgets with values), select the Ignore zeros check circle. However, if it does apply and you want it included in the Average and other statistic calculations, clear the Ignore zeros check circle.
Statistics always ignore null (blank) values. Depending on your suppression settings, some zero values can appear blank.
Ignore baseline tip
The Ignore baseline check circle determines whether the statistic values include or exclude the baseline budget. Select this check circle to exclude the baseline from the statistic values. Otherwise, clear this check circle to include the baseline budget in the statistic calculations. This setting applies anywhere that statistics are visible in Cortex Budget Builder.
Review elements across budgets
Click the Elements tab.
Expand and collapse groups as needed. To collapse all the groups, click
. To expand all the groups, click
.
Set up element quantities (overlines)
- Using a lookup for an element: The administrator selects an attribute to use for the element quantity. Cortex Budget Builder looks up the attribute quantity and uses it for the element quantity. For example, the administrator could configure Cortex Budget Builder so that the Project size attribute is the element quantity for Direct costs.
- Aggregating the quantity for an element: This method adds up all the quantities for the child elements that have a specific unit of measure. The administrator determines the unit of measure to use for aggregating the child element quantities. For example, the aggregate quantity for the Foundations element could be based on CY. In this case, Cortex Budget Builder adds up the quantities for all the child elements (with CY for the unit of measure) in the Foundations group and uses the sum for the Foundations element quantity.
If an element quantity was entered for a project, that quantity displays in the Element quantity column instead of the lookup quantity or aggregated quantity.
Select columns for the comparison
You can select columns (up to five) for comparing budgets in elements view. For example, you might compare the Element quantity, Unit price, and Element total.
Select the compare columns first, and then select the statistic columns for the comparison. Note that a statistic column is available for each of the selected compare columns. For example, if you selected Element quantity, Unit price, and Element total as your compare columns, a statistic column is available for each of them:
- Average: Element quantity
- Average: Unit price
- Average: Element total
- and so on...
To change the element columns for the comparison
- Click
(Settings), and then click Settings in the list. - On the Element columns tab, move columns between the Selected list and Available list to select the desired compare columns (up to five).
To change the element statistic columns
- Click
(Settings), and then click Settings in the list. - On the Element statistics tab, move statistic columns between the Selected list and Available list to select the desired statistic columns.
To reset the default column selections
Click Reset to default in the Configure Grid: More Compare Columns window or Configure Grid: Statistic Columns window, depending on which defaults you want to reset.
Ignore zeros tip
The Ignore zeros check circle determines whether the statistics include or exclude budgets that contain zeros. If a budget in your comparison contains a zero and is not applicable to your scenario (e.g., you are trying to obtain an average of all the budgets with values), select the Ignore zeros check circle. However, if it does apply and you want it included in the Average and other statistic calculations, clear the Ignore zeros check circle.
Statistics always ignore null (blank) values. Depending on your suppression settings, some zero values can appear blank. You can download an import template for a budget to see what values the fields actually contain.
Ignore baseline tip
The Ignore baseline check circle determines whether the statistic values include or exclude the baseline budget. Select this check circle to exclude the baseline from the statistic values. Otherwise, clear this check circle to include the baseline budget in the statistic calculations. This setting applies anywhere that statistics are visible in Cortex Budget Builder.
Display individual factors on the Compare budgets page
How does this work?
When you create a new rate table, Cortex Budget Builder adds an attribute for the table to the project field list. This attribute appears in the list of available fields (in the Factors group) for the Compare Attributes view, giving you the ability to display the factor on the Compare budgets page.
- Click
and select Administration from the menu to open the Administration module. - Click Views > Compare > Compare budgets in the options list.
- Drag the desired factors in the Factors group from the Available list to the Selected list to determine which factors display in Attributes view on the Compare budgets page.
- Drag the factors up or down in the Selected list to determine the order of the factors in the view.
- Click Save.
Change the visible statistic columns
The first column on the Compare budgets page contains the average for each attribute or element, depending on the current tab (Attributes or Elements). Average is one of several available statistic columns (Average, High, Baseline to median, Median, Spread, Low, and more). These columns help you analyze the totals for the budgets being compared.
To change the visible statistics columns
- Click
(Settings), and then click Settings in the list. - Click the Attribute statistics or Element statistics tab based on what you want to change.
- Move the desired columns to the Selected list. Note that the two Baseline statistic columns are available only when a baseline project is specified.
Ignore zeros tip
The Ignore zeros check circle determines whether the statistics include or exclude projects that contain zeros. If a project in your comparison contains a zero and is not applicable to your scenario (e.g., you are trying to obtain an average of all the projects with values), select the Ignore zeros check circle. However, if it does apply and you want it included in the Average and other statistic calculations, clear the Ignore zeros check circle.
Statistics always ignore null (blank) values. Depending on your suppression settings, some zero values can appear blank. You can download an import template for a project to see what values the fields actually contain.
Ignore baseline tip
The Ignore baseline check circle determines whether the statistic values include or exclude the baseline project. Select this check circle to exclude the baseline from the statistic values. Otherwise, clear this check circle to include the baseline project in the statistic calculations. This setting applies anywhere that statistics are visible in Cortex Project History.
Show/hide outliers on the Compare budgets page
- Click
(Settings) in the top right corner of the page. - Click Indicators in the list.
- In the Outliers window, move the Show outliers switch to the on position.
- Select the desired outlier type (Percentage or Standard deviation).
For Percentage outliers, specify theStatistic basis(Average or Median) to use and the threshold percentages for the First and Second thresholds. The outlier arrow points up or down to indicate how it compares to the specified outlier type.
- Click Apply.
Tip
You can show/hide indicators without changing the current indicator options in Settings by moving the Indicators switch (located in the top right corner of the page) to the on or off position.

Show/ hide budget thumbnails (images)
You can show/hide the budget thumbnails by moving the Thumbnails switch (located in the top right corner of the page) to the on or off position.
Reorder the budgets on the Compare budgets page
To move a budget, select the budget image title bar, drag the budget to the desired position, and drop it.
Open a budget from the Compare budgets page
Click anywhere on the project image to open the budget in Cortex.
Remove a budget from the Compare budgets page
- Select the check circle on the project image.
- Click
(Remove budget).
View budget locations on a map
Click
(Maps) to open a map showing the location of all the budgets in the collection. The map works similar to Google Maps. For example, you can switch between showing satellite imagery and the street map.
- To open a popup showing more budget details, hover over the budget pin. Click the budget pin if you want to keep it open.
- To open the budget and see even more details, click the budget name in the popup. The single budget page opens in a separate browser tab.
How does Cortex determine the budget location?
Cortex uses system fields to store a budget's latitude and longitude. Anytime a budget is imported, edited, or refreshed, the system checks the Address line field for a valid address or location to derive the latitude and longitude values. (Note that the administrator can set up an expression for the Address line field that concatenates your separate address fields (address, city, state, and zip) to form a complete address for mapping purposes. If desired, the project name field can be included in the expression too.) Entering a budget-specific address in the Address line field will produce the best result for mapping.
If a valid address or location is not found in the Address line field, Cortex checks the Project location field to see if it can determine a latitude and longitude for the budget.
When you use the mapping feature, only budgets that have latitude and longitude values appear on the map. The quickest way to populate the latitude and longitude fields for all your budgets is to run the Refresh feature in the Administration module.