I am attempting to set up a solid works BOM that i can use for costing new equipment. I found an article through the forum that shows how to do just that. I've been able to replicate it with pretty good success other than item 1.4 Using a few IF statements im able to get the column "Usage" to differentiate between linear feet of a structural member, sq ft of steel plate, and qtys of part numbered items. however item 1.4 doesn't seem to be calculating this value correctly despite using the same equation as every other item for this column. Any insight as to why would be greatly appreciated.
Attached is a zip file containing my parts, assembly, and drawing files. This is a simple test assembly i made just to get my BOM working as i need it to.