AnsweredAssumed Answered

How to count the total amount of each material in a bom ?

Question asked by Max Thulliez on Oct 12, 2016
Latest reply on Oct 13, 2016 by David Durston

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

 

Outcomes