Data formats

Within the field schema you can specify how float data is displayed in the UI using a six part format code like this “,|.|2|£|k|0.001”

The information between the separators denotes;

  • Symbol to use for thousand’s seperator

  • Symbol to use for decimal

  • Number of decimal places to display

  • Symbol to display as a prefix

  • Symbol to display as a suffix

  • Salar to apply to the number

The format code has no impact on how data is stored or used in calculations - only how it is presented in the UI.