Export Assy BOM and do Math functions

[blandb]

I have the parts only BOM tab set with the parameters I need to export, but I need to have a column added to the end in excel for "total Length" where it takes the G_L parameter and multiplies it by the Item quantity. Is there a way to do this? Do I use the GoExcel.CellValue to do this? I am not certain on how how actually accomplish this, I know it is probably something easy I am missing. I thought about setting up spreadsheet as a template with the column needed with a formula, but with the rows of the assembly always changing depending on what is being ran, I'm not certain on how to handle it.

Thanks in advance.

[dusan.naus.trz]

Hi, do you mean something like that?

https://www.youtube.com/watch?v=xv2MN2eMVqM

[blandb]

Don't think so, maybe the images below will help. I made a random assy with random parts.

I have a parts only BOM style configured as shown:

But I want a rule that will export this, but add a new column in the excel file to multiply the G_L cell by the item quantity for parts so I get a total length used as shown in excel:

If there is a way to just rename the column header to be length, and not the parameter name, that would be great!

This way for all cut parts I can use this to tell the shop total linear length of cut shapes from channels, beams or extrusions.  Our drawings only show Item Quantity and length, but does not show a total length, they want this for the shop purposes.

Thanks in advance