A READER ASKS: Converts Any Decimal To A FileMaker Fraction

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts


Hi Dwayne,

Sorry to bother you like this, but I REALLY can't find an answer to this anywhere. I really need to find a formula for a solution I'm working on. If you can help me "great" if not I understand. I'm working in Filemaker Pro 12 Advanced. I got 5 years experience, but some calculation gets the best of me sometime.

Here's what I'm looking for:

I need a calculation that would take any decimal and change it to fraction to the next 1/8 of an inch, but still keep the round number and these fraction 1/4, 1/2, 3/4. My customer do not want to see any 64's and 32's....


.334 would get 3/8
6.763 would get 6 7/8
5.5 would get 5 1/2
9 would get 9

Thanks for the help if you reply.


For things like this, the custom function repository on briandunning.com is the go to place. I just went there and did a search for "fraction" and it returned multiple hits. Try this link ...


© 2013 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.