FMT$( )

 

Returns a String Value
Returns a string consisting of the value of the numeric expression, optionally including a comma and/or a dollar sign, with the specified number of decimal places (rounded to the nearest place).

The first parameter is the numeric expression. The second parameter represents the number of decimal places. The third parameter specifies whether or not to include a comma (0 or no parameter to exclude a comma, any other value returns a comma). The fourth parameter specifies whether or not to include a dollar sign (0 or no parameter to exclude a dollar sign, any other value returns a dollar sign).

Examples:

FMT$(1198,2,1,1)

Returns "$1,198.00"

FMT$(11.98,0,0,0)

Returns "12"

FMT$(11.98,0)

Returns "12"

Other Resources

• Expression Examples
• Filtering Records
• Knowledge Base Article R11493 - All About Expressions
• Knowledge Base Article R11515 - Filter Expression Examples
• Knowledge Base Article R11487 - Working with Indexes, Filters, and QuickViews
• Knowledge Base Article R10750 - Report Writer, Filter, and WorkFlow Functions (provides link to downloadable .pdf)