Brian Dunning's FileMaker Custom Functions

FractionToDecimal ( fraction )

Convert fraction string to decimal

  Average rating: 4.8 (28 votes) Log in to vote

Brett Buchmiller   Brett Buchmiller
None
www.filemaker.com

Share on Facebook Share on Twitter

  Sample input:
FractionToDecimal( "1/4" )

FractionToDecimal( "2 69/95" )
  Sample output:
0.25

2.72631579

  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

 

Comments

L. Allen Poole   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.
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.