Currency ( Amount, Code, Lead, Trail, ShowDecimal, RedNegative )
Format currency as text in many formats (inc. red negative)
Average rating: 4.0 (41 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Format currency as text in many formats. Suitable for displaying currency for multiple countries. Option to display trailing characters. Option to display red negative amounts.
Jul 31, 2009
|With FileMaker 10, "Code" is no longer allowed as a parameter name since it is now the name of an internal function.
A simple change of "Code" to something like "CodeLabel" everywhere in the function will suffice.
|Fergus Black, Peterborough UK
Jan 29, 2010
|Very many thanks - an excellent resource.|
Mar 29, 2010
|This certainly beats:
"$" & Int (Round (Number;2)) & "." & Right (Round (Number;2) * 100;2)
Thank you very much!
|Steve Hearn, London ON
Mar 11, 2011
|Thanks for this. I added another parameter for thousands separator so it has the option of using one or not.|
|Joshua Paul, Neo Code
Sep 10, 2012
|Love this function! Thanks Tony!!!|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.