formatAmount ( amount ; decimalSign )

Formats an amount. Needs my other custom function formatN

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

Martin Spanjaard - Show more from this author
Trias Digitaal
http://www.triasdigitaal.nl

Sample input:

formatAmount( 12345678.9 ; "," )

Sample output:

12,345,678.90

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

Let([
 sign	   = Case( amount < 0  ; "-" )  ;
 amount    = Abs( amount ) ;
 separator = Case( decimalSign = "." ; "," ; "." ) ; 
  decimals = Right( "00" & ( Round(  amount ; 2 ) * 100 ) ; 2 ) ;
  amount   = FormatN( Int( amount ) ; separator ) 
];
  sign & amount & decimalSign & decimals
)

// 26-05-2011 Martin Spanjaard, Trias Digitaal

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

Comments

		David Zakary 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, 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, VR May 28, 2011
Try "0.995".

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

formatAmount ( amount ; decimalSign )

Comments

Support this website.

Support this website.