Overall length of parts with multiple configs

Bear with me while I try and explain this...

A customer has created a tube component with 2 different lengthconfigs (A&B).

Lets say 6 tubes are added into an assembly, 3 at length A & 3at length B

The tubes are bought in 6 metre lengths. In the assembly drawing,the customer wishes to add an equation that will divide the totallength of all the tubes combined by 6000 and then multiply by 1.05to add a little material. This seems an excellent way ofcalculating the amount of tube stock to purchase. However...

When adding a BOM to the assembly drawing, the config specificproperty LENGTH can be added as a column. Unless the differentconfigs are displayed as different items on the BOM, the lengthscannot be added together (if you display all configs as one item,it only uses the length property from 1 config). This means thatthe only way to add the equation is to show the different tubeconfigs as separate items, which is what the customer(understandably) doesn't want to do.

Has anybody got a workaround/macro that could help?

Many thanks

Matt MarshallSolidworksBill Of Materials