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 (for example e.g. for currencies). A default number format can 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. A default number format may be set in system configuration and for each application.
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