A number format specifies how a number will displayed on grid or form , including number of decimal places, whether a thousands separator is required or and any prefix and suffix (e.g. for example for currencies). A default number format may be set for each application or applied to a stream view attribute to format a component in a grid, or applied to a layout component to format forms.
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
Basic Settings
| Field | Description |
|---|
| Number of Decimal Places | Number of decimal places to display | ||||||||
| Suppress Trailing Zeroes | This option is available from version 8.2.8.
| ||||||||
| Prefix | Prefix to display before the number | ||||||||
| Suffix | Suffix to display after the number | ||||||||
| Use Thousands Separator | Whether a thousands separator is required if the number to display is over 1000 | ||||||||
| Decimal Place Offset | How many places to move the decimal separator to the left. This may be desired e.g. where a decimal is going to be displayed as a percentage, in which case a decimal place offset of -2 would be used. |
For example, to format as a percentage, set:
- Suffix to: %
- Decimal Place Offeset to: -2