The display format basically lets you format your Smart number fields the way you want. As the name states, the format will be used to display or present the result of your calculation. Internally the field value is always stored as a number. |
Currently, display formats can only be updated for Smart number fields.
To update the output format you simply have to follow these steps:
|
If your calculated field is being used to store a simple number (e.g. a dollar amount), you have the following formatting options:
Choose a valid pattern and freely use additional characters to indicate the entities (e.g. currencies, weights etc.)
Example field value | Pattern | Displayed value | Description |
---|---|---|---|
123456.789 | ###,###.### | 123,456.789 | Each pound sign (#) denotes a digit, the comma is a placeholder for the thousands separator, and the period is a placeholder for the decimal separator. |
123456.789 | ###.## | 123456.79 | The value has three digits to the right of the decimal point, but the pattern has only two. The last digit will be rounded up. |
123.78 | 000000.000 | 000123.780 | The pattern specifies leading and trailing zeros, because the 0 character is used instead of the pound sign (#). |
12345.67 | $###,###.### | $12,345.67 | Special characters (e.g. the dollar sign $) can be used as a prefix. |
12345.67 | ###,###.### EUR | 12,345.67 EUR | Special characters (e.g. the EUR sign) can be used as a suffix. |
123456.789 | Unformatted | 123456.789 | The value will be returned as stored. |
5100.80 | Custom format, e.g. ###.## kg | 5100.80 kg | Be creative and add suffixes or prefixes. |
When no pattern is entered, a default number pattern is automatically set to unformatted. |