Hello everyone,

I am quite new to bom and I have been struggling with the equations tool for some time but I can't seem to find a way to do what I want.

I made a simple assembly (with some parts and a sub-assembly containing some parts aswell) to test what I would like to do on other large assemblies.

Basically I would like to have each part with its quantity, material and weight regardless of their belonging of a sub-assembly (which I have already done), and also be able to see the total amount of eacht material (for example how much ABS will this assembly require in total ?).

I tried to use equations with SUM and IFs and with columns and custom properties, for example :

IF(`Material`='ABS';`Weight`;0)

in a column so I would just have to SUM the entire column (that I'd call ABS) to have the total amount of this material.

However, beside the fact that this solution is not really practical and general (I would have to create a new column with a new equation for each material), the cells either display 0 (even when the condition is met) or the full equation instead of its result.

Do you have an idea of why it isn't working and how could I do that ?

Thanks in advance

Max Thulliez in your equation ABS needs to be in speech marks ("ABS") and you should be selecting the Material and Weight from the 'Columns' drop down (which should display them in Capitals)

ie:

IF(`MATERIAL`="ABS";`WEIGHT`;0)

Regards

David

EDIT:

p.s. Once you have set it up, save it as a table template and then you can reuse it more easily.