How to Duplicate an Equation in SolidWorks BOM

lloyal · October 27, 2021, 3:50pm

Hello.

I have created a bill of materials that includes unit prices.

I have integrated into a new column and a new cell an equation that multiplies the unit price by the quantity of parts.

Now I'd like to duplicate this formula to the other cells, as suggested by Excel with its handle that we can drag to duplicate

Thank you for your help

capture_3.png
capture_4.png
capture_5.png

Lynk · October 27, 2021, 8:54pm

Hello @l.loyal

To my knowledge Duplicating an equation as described with the SW table seems not possible to me, but with an Excel-based nomenclature I guess it's feasible.

On the other hand, it is possible to link the equation not with the cells but rather with the columns if it can be useful;)

ac_cobra_427 · October 28, 2021, 9:19am

Hello

It's possible to see the example I had made some time ago; To do this, you have to click at the top of the column, then when you have the black arrow, a window will open and there you click on it, then you put your equation there, and there it will be assigned to the column and no longer to a box. Once these are done, you will have to save your new nomenclature.

ac_cobra_427 · October 29, 2021, 7:41am

Hello

Were you able to solve your equation problem?

lloyal · October 29, 2021, 12:20pm

Hello.

Thank you all for the solutions

I'm almost there with the function in the column.

Custom data ("LAST UNIT PURCHASE PRICE") multiplies well with an integer (1,2,3,4,5 etc...).

The only downside is that the Qty of parts (automatically calculated by SolidWorks) should not be considered a number.

So the operation is equal to 0

I keep looking for the value of the "Qty" to be considered as a number.

Thank you again for your help

capture_6.png
capture_7.png

Lynk · October 29, 2021, 2:41pm

I confirm what I said in the previous message about:

The nomenclature in Excel format allows you to do the manipulation in question (the trick of sliding via the small +) capture 0 and 01.
The fact of linking the columns to the places of the cells in ka table has a solidworks base. Capture 02

@l.loyal regarding the text format thinks of using the combobox or instead of entering the name of the column which indeed a text (the title of the column) not necessarily the same name of the property;)

capture_0.png
capture_1.png
capture_2.png