Expressions.expr-primary-format
Use FORMATVALUE to return a string that is formatted according to the instructions that are contained in a format String expression.
Format
FORMATVALUE( Value USING Format )
Remarks
The Value is formatted using the format that is specified by the Format argument, and returns the result as a String. The Value argument can be any type of expression. The Format argument can be any character string expression.
For a description of the options allowed in the Format argument, see Define a Custom Value Format.
FORMATVALUE( 12.5 USING '#0.0000' ) returns '12.5000'
FORMATVALUE( DATE '2025-08-02' USING 'EEEE, MMMM d, yyyy' ) returns 'Wednesday, August 2, 2025'
FORMATVALUE( 1000000 USING '#,###' ) returns '1,000,000'
FORMATVALUE( 1000000 USING '0E0' ) return '1E6'