Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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. 


FieldDescription
NameName of the Number Format
Number of Decimal PlacesNumber of decimal places to display
PrefixPrefix to display before the number
SuffixSuffix to display after the number
Use Thousands SeparatorWhether a thousands separator is required if the number to display is over 1000
Decimal Place OffsetHow 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.


Example: format as a percentage

FieldValue
Suffix%
Decimal Place Offset-2