Need help displaying height in feet and inches

[jpeters01]

This is my @HtIn formula that displays height in inches:

if {casevisitresultlistwt.label_seq} = 9997 then left({casevisitresultlistwt.result_value},2) else ''

This formula returns values, for example, of 65, 73, 40. I need to display this as feet and inches in two separate columns. Like this:

Ht In
5 5
6 1
3 4

Can you please help with one formula that displays feet, and another formula that displays inches?

 

[pmax9999]

Assuming you want it in two separate columns, create the following 2 formulas:

[Code FEET]
Truncate({@HtIn}/12)
[/Code]

[Code INCH]
Trunmainder({@HtIn},12)
[/Code]

Cheers
Pete

 

[BettyJ]

Hi Pete,
I believe you meant Remainder.

 

[hilfy]

You could also use this to get the feet:

{@HtIn} \ 12 <--The backslash operator (\) is "Integer Divide"

And this to get the inches:

{@HtIn} mod 12 <--Mod (or "modulus") is the remainder of an integer division.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com