⨐ Formulas in Join

Join allows you to perform calculations by entering a formula in a Join data grid, such as the Milestone Estimate and Budget and Items. Formulas can be added to any editable numerical cell, such as unit price or quantity. 

Creating a formula

  • Double click a numerical value cell
  • Type the equal sign =
  • Enter the formula you want to calculate e.g. 2*5
  • Press Enter
  • The result of the calculation will appear in cell

Referencing other cells

Within a formula, you can reference numerical cells in other columns and rows within the same table using the following syntax [Line Number].[Column] e.g. L10.Quantity


If using the detailed cost type breakdown, you can reference cells under each cost breakdown by including the breakdown name e.g. L10.Material.Unit Price.

Note: Cell references should include spaces for columns such as Unit Price

Supported Operations

Arithmetic operators

Meaning

Example

+ (plus sign)

Addition

=3+3

– (minus sign)

Subtraction

Negation

=3-3

=-3

* (asterisk)

Multiplication

=3*3

/ (forward slash)

Division

=3/3

% (percent sign)

Percent

30%

^ (caret)

Exponentiation

=3^3

Correcting errors in formulas

If your formula isn’t accepted or contains an error, you will see a red ! in the cell, hover over this to get a detailed explanation of the error.