Conversion of Height Stored in Inches

[eric333]

I have a field in which a person's height is stored in inches. Someone who is 6'2" has a value stored as 74". How can I convert the stored value to the more comment format of feet, inches?

 

[SkipVought]

Hi,

Don't they teach basic math in California?

12 inches per foot, is the coinversion factor.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[eric333]

I was absent the day it was taught. Yeah, I know the conversion factor. What I don't know how to do in Crystal is write a formula that handles the conversion and displays the information in the desired format.

 

[lbass]

numbervar x := {table.number};
totext(truncate(x/12),0,"")+"'"+totext(remainder(x,12),0,"")+'"'

-LB

 

[eric333]

Thank you and saved for future use.

 

[SkipVought]

A simple version...
[tt]
ft = INT([inches]/12)
in = [inches] - ft * 12
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}