Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Decimal to Fraction 2
- Thread starter bkrampe
- Start date
-
1
- #3
smcnulty2000
Technical User
Crystal can't do it without a formula, the way you can in Excel.
The problem is that crystal never sought this as a priority item to include.
You might try working with the DollarFR() function.
You also might consider writing your own function. That pretty much turns this into a lookup that tries to determine which bracket the number falls inside of.
Here is an example:
You might wonder where I got the numbers. All I did was get excel out, build a set of rows that divided each of the numbers from 1 to 16 using 16 as the denominator. So 1/16, 2/16, etc.
Then I just averaged a given cell with the one above it. So the decimal of 1/16 is .0625 and the decimal of 2/16 is .15625. The average of these is .09375, which takes care of rounding. It is equivalent of 1.5/16
I would probably turn this into a function. And drop the formula onto the canvas, reduce the font.
But that's just one approach.
You could also take the above formula and turn it into two formulas, one for numerator, one for denominator. Then place these on the canvas one above the other with a slash (solidus) or horizontal bar (vinculum) between them.
The problem is that crystal never sought this as a priority item to include.
You might try working with the DollarFR() function.
You also might consider writing your own function. That pretty much turns this into a lookup that tries to determine which bracket the number falls inside of.
Here is an example:
Code:
local numbervar numSource:={@SourceNumber};
local numbervar numWhole:=0;
local numbervar numRemainder:=0;
local stringvar strRemainder;
numWhole:=truncate(numSource);
numRemainder:=numSource-numWhole;
strRemainder:=
select numRemainder
Case is < .09375:
"1/16"
Case is < .15625:
"1/8"
Case is < .21875:
"3/16"
Case is < .28125:
"1/4"
Case is < .34375:
"5/16"
Case is < .40625:
"3/8"
Case is < .46875:
"7/16"
Case is < .53125:
"1/2"
Case is < .59375:
"9/16"
Case is < .65625:
"5/8"
Case is < .71875:
"11/16"
Case is < .78125:
"3/4"
Case is < .84375:
"13/16"
Case is < .90625:
"7/8"
Case is < .96875:
"15/16"
default:
" ";
strRemainder;You might wonder where I got the numbers. All I did was get excel out, build a set of rows that divided each of the numbers from 1 to 16 using 16 as the denominator. So 1/16, 2/16, etc.
Then I just averaged a given cell with the one above it. So the decimal of 1/16 is .0625 and the decimal of 2/16 is .15625. The average of these is .09375, which takes care of rounding. It is equivalent of 1.5/16
I would probably turn this into a function. And drop the formula onto the canvas, reduce the font.
But that's just one approach.
You could also take the above formula and turn it into two formulas, one for numerator, one for denominator. Then place these on the canvas one above the other with a slash (solidus) or horizontal bar (vinculum) between them.
-
1
- #4
bkrampe,
Ken Hamady posted a formula yesterday to do this (on his site):
Andy
Ken Hamady posted a formula yesterday to do this (on his site):
Andy
- Thread starter
- #5
smcnulty2000
Technical User
Cool, I'll try it myself.
Ken's stuff is usually pretty solid.
Ken's stuff is usually pretty solid.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question