The bill of materials has two empty columns, PRICE and COST. Use custom properties and equations to fill the columns.
-
Select the PRICE column by
moving the pointer just above the column and double-clicking when the pointer
changes to
.
- On the pop-up toolbar, select Column Property
. In the dialog box:
- Select Custom Property under Column type.
- Select Price under Property name.
The price for each component has been saved in the parts. The column populates with the price of each component.
- Click outside of the dialog box to close it.
- Select the COST column.
- In the pop-up toolbar, click Equation
.
- In the dialog box:
- Under Precision, select .12.
{2} appears. Place the cursor after {2}.
-
Under Columns,
select manual explode/QTY.
- Type * (for multiplication).
- Under Custom properties, select Price.
-
Click
.
The equation appears as {2}'manual
explode/QTY.'*'Price'. The equation calculates the quantity of
each component multiplied by the price per unit, to give the total cost of the
component.