PercentToText ( FIELD )
Converts percent into words suitable for real estate leases, etc.
Average rating: 4.7 (24 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Converts number meant to be a pecentage into text formatted for a real estate lease, etc., Thus 23.42 would become Twenty-Three and 42/100 (123.42%) percent. Function only goes up to 999.99%
Will Loving, Dedication Technologies, Inc.
Feb 6, 2014
The function isn't particularly efficient on the fraction part. It also doesn't handle something like 0.7% correctly as a fraction, converting it to 7/100 instead of 70/100.
I would take the last section that deals with the fraction and replace it with this:
Right( "00" & Mod( Int( Start amount *100 ) ; 100 ) ; 2 )
the first section could be shortened slightly by taking "Hundred" out from each choice and adding it to the end of the calculation.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.