numberAbbreviate ( number ; precision )

Shorten number with unit prefix (thousands = k, millions = m, billions = b... )

Average rating: 5.0 (1 vote) Log in to vote

Philip McGeehan - Show more from this author
SMD Ltd
http://philipmcgeehan.com

Sample input:

numberAbbreviate ( 666 ; 1 )
numberAbbreviate ( 7666 ; 1 )
numberAbbreviate ( 7666 ; 2 )
numberAbbreviate ( 65465999 ; 3 )

Sample output:

666
7.7k
7.67k
65.466m

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

Let ([	n = number ;
	p = precision ;
	m = Round ( Abs ( n ) ; 0 )
] ;
	If ( n < 0 ; "-" ) /* if n was negative add the symbol */
	& 
	Case (
	/* <1 thousand - just show rounded n */
		m < 10^3 ;
		m ;

	/* thousands */
		m < 10^6 ;
		Round ( m / 10^3 ; precision ) & "k" ;

	/* millions */
    		m < 10^9 ;
		Round ( m / 10^6 ; precision ) & "m" ;

	/* billions */
    		m < 10^12 ;
		Round ( m / 10^9 ; precision ) & "b"
	;
	/*if none of the above, show the rounded n */
		m
	) //end Case
)

For displaying a shortened format of a given number with rounding precision (up to 3 decimal places).
Thousands, Millions and Billions.

Comments

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

numberAbbreviate ( number ; precision )

Comments

Support this website.

Support this website.