⨐ 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
  • Press the equal sign =
  • Enter the formula you want to calculate e.g. 2*5
  • Press Enter
  • The result of the calculation will appear in the cell

Note: Cells containing formulas will display an underlined value.

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

Caution: Column references should include spaces for column names such as "Unit Price". 

Caution: Row references are case-sensitive but column references are not. Use "L10", not "l10" for row references. Use either "Quantity" or "quantity" for column references.

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 an Error icon in the cell, hover over this icon to get a detailed explanation of the error.