You can define table entries using mathematical operations on custom properties. In this BOM table example, multiply the value of the custom property Unit Cost with the component quantity to calculate the total cost.
- Add a new column to the table and label it as necessary.
- From the table, click a cell or column heading and for Column type, select Equation.
- Click the Equation tool
.
-
Enter the equation 'QTY.'*'Unit Cost' in the equation text field.
To ensure correct spelling of property and column names, select
QTY. from
Columns and
Unit Cost from
Custom properties when entering the equation.
The
* operator multiplies the two numerical values. You can also use other mathematical operations such as
+ or
/.
-
Click
.
To populate the table with a calculation based on a unit cost custom property, the custom property
Unit Cost must be defined for each BOM entry. You can type missing unit cost values to update the table.