I added a column in BOM chat, I renamed the column as ' Cost' by chosen 'custom property / cost ', but how to calculate the ' total cost'?
I added a column in BOM chat, I renamed the column as ' Cost' by chosen 'custom property / cost ', but how to calculate the ' total cost'?
Or maybe i should ask how to create the ' Total cost' column?As i understand that should go to the assembly component or single part file, then create it in 'property', exactly how, i m not so sure about it...
Hi Yijing,
You might receive more helpful replies by posting in the correct category. (This post doesn't seem related to '3D ContentCentral')
In any case to achieve a 'total cost' you will need to try the following:
Add a 'Cost' custom property to parts/assemblies as required. To do this follow these steps:
2016 SOLIDWORKS Help - Accessing Custom and Configuration Specific Properties
2016 SOLIDWORKS Help - Adding Custom Properties
(I included these since it sounds like you don't know how to do this?)
In your Assembly BoM or Drawing BoM, add a new column and select the custom property 'Cost' to be displayed in this column.
Add another new column which will be 'Total Cost'. Add an equation which is ='Cost' column * 'Quantity' column. This will give you total cost of the parts for the required quantity.
The table can be saved at this point to re-use in future assemblies/drawings.
Finally insert a row at the bottom, click the cell below Total Cost which is empty and select 'Equations', add a 'sum' and highlight all remainder of cells under Total Cost for which it will sum. This should give you all the desired costing information for your assembly.
Hi, Logan, thanks very much for help!! i will try your method,
Hi, Logan, it is really works, i made it through your way, thanks again!!
Hi Yijing,
You might receive more helpful replies by posting in the correct category. (This post doesn't seem related to '3D ContentCentral')
In any case to achieve a 'total cost' you will need to try the following:
Add a 'Cost' custom property to parts/assemblies as required. To do this follow these steps:
2016 SOLIDWORKS Help - Accessing Custom and Configuration Specific Properties
2016 SOLIDWORKS Help - Adding Custom Properties
(I included these since it sounds like you don't know how to do this?)
In your Assembly BoM or Drawing BoM, add a new column and select the custom property 'Cost' to be displayed in this column.
Add another new column which will be 'Total Cost'. Add an equation which is ='Cost' column * 'Quantity' column. This will give you total cost of the parts for the required quantity.
The table can be saved at this point to re-use in future assemblies/drawings.
Finally insert a row at the bottom, click the cell below Total Cost which is empty and select 'Equations', add a 'sum' and highlight all remainder of cells under Total Cost for which it will sum. This should give you all the desired costing information for your assembly.