FractionToDecimal ( fraction )
Convert fraction string to decimal
Average rating: 4.8 (28 votes) Log in to vote
FractionToDecimal( "2 69/95" )
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Converts a fraction string to a numeric decimal equivalent. Part of a library of functions. Needed additional functions are mentioned in the header comments
L. Allen Poole, Creative Database Solutions NW
Dec 4, 2013
This function appears to fail on integer inputs.
FractionType ( 12 ) returns "Invalid," so FractionToDecimal ( 12 ) returns [null].
Rather than test for integer inputs every time I use this function, I modified it to return integer inputs unmodified.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.