Brian Dunning's FileMaker Custom Functions

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   Daniele Raybaudi
ACI
http://www.aci.it

Share on Facebook Share on Twitter

  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.

 

Comments

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.

Under construction. Email me your wish list for improvements.