Definition
The FORMAT() function formats a value with the specified format. Use the FORMAT() function to format date/time values and number values. For general data type conversions, use CAST() or CONVERT().
Syntax
FORMAT(value, format)
where
value is required and is the value to be formatted.
format is required and is the format pattern.
Example(s)
What to use in Custom SQL field:
FORMAT([ASSIGNMENT COMP & PAYROLL INFO: Current Annual Base Pay Amount] ,'#,###')
FORMAT([ASSIGNMENT COMP & PAYROLL INFO: Current Annual Base Pay Amount] ,'#,###.00')
Note: Use the MAX Aggregate function for the Custom SQL Field
