I have a table that holds individual defect data that are detected on a long piece of material. The table includes the following fields:
Height (Length of Defect)
Width (Width of Defect)
BoxTop (Distance from from Head End to Defect Top)
BoxBottom (Distance from Head End to Defect Bottom)
In the attached image, you will see a representation of a 45 foot long piece of material with yellow defects.
I want to calculate the the length (linear feet) of prime material (zero defects across width of material).
Note that that some defects overlap. I do not want to double-count these non-prime areas along the length of material.