To format number fields in form letter and emails, use syntax similar to the following: {Invoice.Balance(<format>)} where <format> is similar to one of the following:
Format | Description | Syntax | Example Result for "1234.567" |
0 | Show the number as an integer | {Invoice.Balance(0)} | 1235 |
0.0 | Show the number as a floating point number with one decimal place | {Invoice.Balance(0.0}) | 1234.5 |
0.00 | Show the number as a floating point number with two decimal places | {Invoice.Balance(0.00}) | 1234.57 |
00000.0 | Show the number with at least 5 digits and one decimal place (prefixed with 0) | {Invoice.Balance(00000.0}) | 01234.6 |
#,##0.0 | Show the number with at least 1 digit and one decimal place, with commas separating thousands. | {Invoice.Balance(#,##0.0}) | 1,234.6 |