Skip to main content
Procore (en-GB)

Create a Calculated Column in a Custom Report

Objective

To create a calculated column to add to your custom reports.

Background

You can create calculated columns in custom reports in order to gain more insight to data by creating basic arithmetic calculations.

Things to Consider

  • Required User Permissions: 
    • 'Admin' level permissions on the Project level Reports tool and 'Admin' level permissions on the tool that is being reported on. 
  • Additional Information:
    • Calculated columns are sortable.
    • Calculated columns persist within any one given report.
    • Created calculated columns cannot be used for other calculations.
    • Calculated columns created by a customer are associated with a specific report and cannot be used on other reports.

Steps

Create a Calculated Column in a Custom Project Report

  1. Navigate to the Project level Reports tool.
  2. On the Reports tab, locate the report that you want to add the calculated column to.
  3. Click the vertical ellipsis icon-ellipsis-options-menu.png and select Edit.
    OR
    Click the report to open it and then click Edit in the sidebar.
  4. Under Custom Columns, click +Create Calculation.
  5. In the New Calculation window, update the following fields:
    • Calculation Name: Enter a title for the new column you are creating. 
    • What would you like to calculate?: Select one of the following output types: Percentage, Currency, Number or Date Variance.
    • Column X: Select a column from the drop-down menu to use in the calculation.
    • Operator: Select one of the following operators to use in the calculation: +, -, x or /.
    • Column Y: Select a second column from the drop-down menu to use in the calculation.
    • Optional: Click +Add row to add another operation and column to the calculation.

      reports-new-calculation.png
       
  6. Click Save to save the column or click Save & Create New to save the column and to create a new calculated column.
    Your calculated column will appear in your custom report, but the calculated values will not be visible until after you save the report.
  7. Optional: To create an aggregate for that column's data, see Aggregate Data in a Custom Project Report.
  8. Click Update Report.

Create a Calculated Column in a Custom Project Report - Enhanced Reporting

To add a calculated column to custom report created using Enhanced Reporting (see Create a Custom Company Report - Enhanced Reporting), follow the steps below:

Basic Calculation

  1. Navigate to the Project level Reports tool.
  2. On the Reports tab, locate the report that you want to add the calculated column to.
  3. Click the vertical ellipsis icon-ellipsis-options-menu.png and select Edit.
    OR
    Click the report to open it and then click Edit.
  4. Click the calculator icon-calculator.png icon.
  5. Click Create New Custom Column.
  6. Enter a name for the column in the Name field.
  7. Optional: Enter a description for the column in the Description field.
  8. Select Basic Calculation from the Column Type drop-down menu. This option lets you add, subtract, multiply, and divide numeric values in columns.
  9. Select the first value to use in the calculation. If you select Constant, enter a number to use as the value.
  10. Select the type of calculation you want to perform: + (add)- (subtract)x (multiply), or ÷ (divide).
  11. Select the second value to use in the calculation. If you select Constant, enter a number to use as the value.
  12. Select the format you want to use for the calculated column: # Number, $ Currency, or % Percent.
  13. Select the number of decimal places to be displayed: Ones (1), Tenths (1.0), Hundredths (1.00), Thousandths (1.000), Ten Thousandths (1.0000), Hundred Thousandths (1.00000), or Millionths (1.000000).
  14. Click the Rounding toggle ON or OFF.
  15. Click Save to add the calculated column to your report.
  16. Click Update Report to save the changes to your report.

Date Variance

  1. Navigate to the Project level Reports tool.
  2. On the Reports tab, locate the report that you want to add the calculated column to.
  3. Click the vertical ellipsis icon-ellipsis-options-menu.png and select Edit.
    OR
    Click the report to open it and then click Edit.
  4. Click the calculator icon-calculator.png icon.
  5. Click Create New Custom Column.
  6. Enter a name for the column in the Name field.
  7. Optional: Enter a description for the column in the Description field.
  8. Select Date Variance from the Column Type drop-down menu. This option allows you to find the difference in days between two dates or add (or subtract) days from a specific date.
  9. Select the first value to use in the calculation.
  10. Select the second value to subtract from the first value. If you select Constant, enter a number to use as the value.
  11. Click Save to add the calculated column to your report.
  12. Click Update Report to save the changes to your report.