Brian Dunning's FileMaker Custom Functions

formatAmount ( amount ; decimalSign )

Formats an amount. Needs my other custom function formatN

  Average rating: 5.0 (29 votes) Log in to vote

Martin Spanjaard   Martin Spanjaard
Trias Digitaal
http://www.triasdigitaal.nl

Share on Facebook Share on Twitter

  Sample input:
formatAmount( 12345678.9 ; "," )
  Sample output:
12,345,678.90

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

I think the function is very easy to read. Can handle amounts of any length.

 

Comments

David Zakary   David Zakary, Toronto
May 26, 2011
There is an error in either this function or fomatN. If I enter formatAmount (123456789; ",") I get the following "?,789.00" returned
 
Martin Spanjaard   Martin Spanjaard, Trias Digitaal
May 26, 2011
Hi David,

The separator in the let had the period and comma in the wrong order. Can you try once more?
By the way, which version of FMP do you use?

Martin Spanjaard
 
comment   comment, VR
May 28, 2011
Try "0.995".
 

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.