We had a BOM formula that worked perfectly when created, but when saved as a Template and reinserted one column driven by an equation just stubbornly refused to work.
It looks like a bug,,, but if you delete a value in the column the formula wake's up again and all is good in the world.
SolidworksDrawings And Detailing