### Title

Calculation Field Format - How to Override

### Post

Hello,

I have a calculation field that adds two height measurements. The calculation however shows a result as a number even when the field is defined to result in text. I need the result to be in inches/feet since it's a height measurement.

The source fields which is providing the calculated criteria are both entered in inches/feet but yet the result is always a number. So if 5'6" is entered, the calculation result is coming to 56.

Is there a way to override this? Since it is a calculation field it is not modifiable.

Thanks!

Please read my last post again:

You apparently have this calculation:

Let ( [ Camera Height From Floor = GetAsNumber ( Leftwords ( Camera Height From Floor ; 1 ) ) ;

Let ( [ Camera Height From Floor

Feet= GetAsNumber ( Leftwords ( Camera Height From Floor ; 1 ) ) ;Inches= GetAsNumber ( Rightwords ( Camera Height From Floor ; 1 ) ) ;Feet= GetAsNumber ( Leftwords ( Floor Height From Ground ; 1 ) ) ;Inches= GetAsNumber ( Rightwords ( Floor Height From Ground ; 1 ) ) ;Inches+ Camera Height From GroundInchesFeet+ Camera Height From GroundFeet+ Div ( Iab ; 12 ) & "' " & Mod ( Iab ; 12 ) & "\""