Calculation Field Format - How to Override
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.