-
Click
. Find
- Press ENTER.
- In the BOM List panel, right-click the BOM to edit and select Set current. The
icon indicates the current BOM.
- Place the cursor in the cell you want to create the formula for.
- In the Formula Bar, click
. The Expression Builder dialog box is displayed.
- In the Select value type list, select Formula.
- In the expression box, add references, operators, and functions as required.
For example, to create a formula for Cost truncated to the nearest dollar (Integer value of Price × Quantity):
- In the Category list, select Function.
- In the Select list, select INT and click Add. The Expression area shows =INT().
- In the Expression area, place the cursor between the brackets.
- In the Category list, select BOM Properties.
- In the Select list, select QTY (quantity) and click Add. The program adds the reference <QTY> to the expression area.
- Type the asterisk character (*) after <QTY>.
- In the Select list, select PRICE and click Add. The formula =INT(<QTY>*<PRICE>) is complete.
- Click OK.