Newest functions Upload a function Leave a tip My account

There are 2,521 functions in this library.

FormatThousands ( Number ; Precision ; Separator )

Formats a number separating the thousands by a user specified character.

  Average rating: 4.1 (34 votes) Log in to vote

Rob Poelking - Show more from this author Kiza Solutions https://kizasolutions.com

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

/* Name: FormatThousands Params: Number; Precision; Separator Function: Author: Rob Poelking */ Let ([ N = Abs ( Int ( Number ) ); m = Abs (Number ) - N ; neg = If ( GetAsNumber (number) < 0 ; "-" ; "" ) ; L = Length ( N ) ; i = Mod ( L ; 3 ) ; F = If ( L >= 3 ;Right ( N ; 3 ) ; Right ( N ; i ) ); R = If ( L > 3 ; Left ( N ; L - 3 ) ; "" ) ]; neg & If ( R ≠ "" ; FormatThousands (R ; 0 ; separator ) & separator & F ; F ) & If ( m > 0 ; "." & Repeat ( "0" ; Precision - Length ( Round ( m * 10 ^ Precision ; 0 ) )) & Round ( m * 10 ^ Precision ; 0 ) ; if ( precision > 0 ; "." & repeat ( "0" ; Precision ) ; "" ) ) ) /* Notes: Relies on the Repeat ( char ; Num ) function. Defined as follows: If (number > 0 ; char & If ( number > 1 ; Repeat ( char ; number - 1) ; "") ; "" ) */ Click to copy

Formats any real number separating the thousands position by a user specified character and also specifies the precision of digits after a decimal.

 

Comments

		Gary Amstutz, Sweetwater Feb 9, 2016
This function works great, but it won't work with negative numbers properly. Try changing the fifth line to: neg = If ( GetAsNumber ( number ) < 0; "-"; "") ; and that should fix it. If you need a function that doesn't force the result to a fixed length decimal number, try FormatThousands (textNum) found at https://www.briandunning.com/cf/1853

		Rob, Monk Media Feb 10, 2016
Thanks Gary, I wrote that some time ago and honestly can't remember why I wrote it that way.

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 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: