⨐ 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.