Tableau Calc field syntax - inches to feet

Question

Can somebody assist me with the syntax for creating a calculated field in Tableau? I have a list of inches of height data that I'd want to convert to feet and inches.
72 inches, for example, is equal to 6 feet. 6.08 to 73 feet (or rounded to 6.1). Any assistance is much appreciated.

Answer 1

If your current field is named height, the computation is as follows:

[height] / 12

To set default format (round to 1 decimal place), right click on the field and select Default Properties -> Number Format -> Number (Custom) -> 1 decimal place.

Review this documentation for getting started with calculated fields.

https://onlinehelp.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_create.html