FormattedNumber ( number ; thousandSep ; red )

Returns any gived number as a number formatted with thousand and decimal separators.

Average rating: 4.3 (28 votes) Log in to vote

Daniele Raybaudi - Show more from this author
ACI
http://www.aci.it

Sample input:

FormattedNumber ( -1234,12; "."; 1 )

FormattedNumber ( -1234,12; "."; 0 )

Sample output:

-1.234,12 (RED)
-1.234,12 (BLACK)

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

/*

FormattedNumber custom function

Author: 
Daniele Raybaudi

Format:
FormattedNumber ( number ; thousandSep ; red )

Parameters:
number - any number or  number field
thousandSep - the your choice thousand separator (decimal separator is given by your system settings) 
red - Boolean number - if the number is a negative one and this parameter is  ≠ 0, the result will be red writhed

Returns any given number as a number formatted with thousand and decimal separators.
Also you can choose to display the result in red if the number is a negative one.
Better than other custom functions because this isn't limited to some separators and doesn't need sub custom.

March 16, 2006

*/

Let ([
negative = If ( Length ( Filter ( number; "-" )) and number ; 1; 0 );
num = Abs ( number );
int = Int ( num );
dec = num - int ;
len = Length ( int );
tris =
Case ( 
len > 3 and dec ; thousandSep & Right ( int ; 3 ) & dec;
len ≤ 3 and dec ; Right ( int ; len ) & dec;
len > 3 ; thousandSep & Right ( int ; 3 ) ;
Right ( int ; len )
);
next = Left ( int ;  len - 3 );
result = Case (
len  ; FormattedNumber ( next ; thousandSep ; red ) &  tris ;
""
)
] ;
Case (
negative and red ; TextColor ( "-" & result ; RGB ( 255 ; 0 ; 0 ) ) ;
negative ; "-" & result ;
result
)
)

FormattedNumber custom function

Author:
Daniele Raybaudi

Format:
FormattedNumber ( number ; thousandSep ; red )

Parameters:
number - any number or number field
thousandSep - the your choice thousand separator (decimal separator is given by your system settings)
red - Boolean number - if the number is a negative one and this parameter is ≠ 0, the result will be red writhed

Returns any given number as a number formatted with thousand and decimal separators.
Also you can choose to display the result in red if the number is a negative one.
Better than other custom functions because this isn't limited to some separators and doesn't need sub custom.

Comments

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

FormattedNumber ( number ; thousandSep ; red )

Comments

Support this website.

Support this website.