0 Replies Latest reply on Oct 15, 2015 3:30 PM by Trevor Hall

    BOM Equation with IF Statement

    Trevor Hall

      I have a BOM with QTY of whole numbers, and extruded lengths in "in" (inches).  I want the equation to say IF THE QUANTITY IS IN INCHES, I WANT TO SEE IT IN FEET INSTEAD.

       

      The equation to convert is okay with {1}'QTY.'/12" FT", but it messes up the whole numbers.  Hence the need for an IF statement.