A number format specifies how a number will displayed on grid or form including number of decimal places, whether a thousands separator is required and any prefix and suffix (e.g. for currencies). A default number format may be set for each application or applied to a stream view attribute to format 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 |
| 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