Brian Dunning's FileMaker Custom Functions

PercentToText ( FIELD )

Converts percent into words suitable for real estate leases, etc.

  Average rating: 4.7 (24 votes) Log in to vote

Randy Fowler   Randy Fowler

Share on Facebook Share on Twitter

  Sample input:
PercentToText ( 123.42 )
  Sample output:
One Hundred and Twenty-Three and 42/100 (123.42%) percent

  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%

 

Comments

Will Loving   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.
 

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.