GetAsCurrency ( Label, Num, RedNegative )
Formats any number into currency
Be the first to rate this function Log in to vote
Kyle Williams - Show more from this author
GetAsCurrency ( "$", -112312000.1234, 0 )
GetAsCurrency ( "$", -112312000.1234, 1 )
$-112,312,000.12 //This will use the default text color
$-112,312,000.12 //This will show in Red text
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Formatting a number as currency has always been a challenge. This is the simplest formula I've been able to come up with for tackling this challenge...
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.