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.