Applying an equation function

Here, we will apply the Total function in our BOM. Using this function, we will add all of the values under TOTAL COST PER PART (USD), which we just created. This will give us the total cost per coffee table. To do this, we can follow these steps: 

  1. Add a new empty row at the bottom of the table. We can do that by right-clicking any cell at the bottom and inserting a row. 
  2. Select the cell bottom cell under the TOTAL COST PER PART (USD) column and select Equation (Σ).
  3. In the equations panel, select TOTAL under the Functions drop-down menu, as highlighted in the following screenshot. Once we select that, the word TOTAL will appear in the equation space:

  1. Click on the green checkmark. Then, the value of the last cell (cell E8) will change to 96, which is the sum of all of the numbers in that column. To make the table clearer, we can add the word TOTAL in cell D8. The resulting BOM will be as follows. Note that, when editing cell D8, SOLIDWORKS will ask us whether we want to break the link in the cell and continue editing it; click Yes to edit: 

  1. It is good practice to try cleaning our bill as much as possible. For example, in the preceding bill, we can remove item number 7 as that row only has the total and does not include an item. To hide that item number, we can right-click on that cell and select Hide Item Number, as highlighted in the following screenshot: 

This concludes our work with equations within BOMs. Using equations will allow us to generate new numerical information in our table that is not linked to a particular part. A common application of equations is in relation to the costs of parts. Next, we will learn how to add callouts to the assembly for easier referencing between our bill and the visual display of the assembly. 

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.145.93.210