Number Format

Owned by Eleanor Brodie
Last updated: Aug 31, 2022 by Fiona Sargeant (Unlicensed)

Overview

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 view attribute to format a grid, or applied to a layout component to format forms. 

Property Pane Toolbar

For information about the toolbar options, see the Common Properties page, Toolbars and Controls section.

 Properties Tab

Parent Details

If this item is within or belongs to another, it's parent name is shown here. See the Common Properties page, Parent Details section for more details.

Basic Settings

FieldDescription
NameEnter the name for the number style.
Number of Decimal PlacesEnter the number of decimal places to display.
PrefixEnter a prefix to display before the number.
SuffixEnter a suffix to display after the number.
Use Thousands Separator

For numbers over 1000,  Tick to include a thousands separator.

Decimal Place OffsetEnter the number of decimal places to move the decimal separator. Negative numbers move the decimal point to the left.
For example, if the decimal will be displayed as a percentage, you need to offset the decimal place by -2.
Suppress Trailing Zeroes

Select one of the following:

  • Keep trailing zeroes
    T    he number is displayed as entered, with trailing zeroes preserved.
  • Suppress trailing zeroes
    PhixFlow does not display trailing zeroes, except the first after a decimal point. Examples of a number entered as:
    • 1.50 is stored as 1.5
    • 23.000 is stored as 23.0

For example, to format as a percentage, set:

  • Suffix to: %
  • Decimal Place Offeset to: -2


Description

We recommend that you always enter a description to explain the purpose of this item.

 Audit Tab

Audit Summary

See the Common Properties page, Audit Summary section.

Sections on this page