5 Replies Latest reply on Jun 2, 2012 3:36 PM by Richard Leeke

    Converting Feet to Inches?

    Paul Hamrick

      Hello All!


      I'm a brand new Tableau user (2 days) and I was hoping someone might be willing to help with a conversion problem I'm facing. 


      My problem is that I have height data that was captured in feet and inches, instead of in inches.  The cell data is captured as:  [ 5'7" ] with the foot and inch suffix.   


      I'd like to do a BMI calculation in the Viz that requires the height data be in Inches, but can't seem to come up with a Field Calculation for the conversion from Feet and Inches to Inches?  Is there a work around in Tableau for problematic formatting?   Any help would be so appreciated!


      Thank You!