From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer
Layout field options are often overlooked or perhaps I should say the levels of flexibility in field layout formatting is often overlooked. Number formatting options are very robust. You can choose from the following options.
Leave Data As Formatted - shows the number with none of the formatting applied
Format As Boolean - means that a number is going to be represented as either zero or something other than zero. You can specify what characters can mean a zero result or the non zero result.
Format As Decimal - Allows you to format a number with a fixed number of decimal places. Allows you to use a notation such as percent, currency ( leading ) and currency ( trailing ). You can also specify the currency symbol that will be used. The final option for this format is to not display the number if it is zero.
You can also format a number to have a specific separator for the decimal point or the thousands. You can even choose to use a separator other than the classic period for decimal and comma for thousands.
You can also decide how negative numbers will appear on the layout and even choose a custom color for when negative numbers occur.
At the bottom of the Number Format dialog box, you can see a sample of the settings you have selected.
More info about the author and FileMaker in general, contact me at firstname.lastname@example.org.
© 2008 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.