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 - Show more from this author
Trias Digitaal

Share on Facebook Share on Twitter

  Sample input:
formatAmount( 12345678.9 ; "," )
  Sample output:

  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.



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 Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: