Skip to main content
Number fields only accept numerical input, including integers and decimals, such as “12”, “3.1415”, etc. The field will automatically filter out any non-numeric characters. Number fields can have range restrictions set to only allow input within specified intervals. Number fields can be used for sorting and filtering, quickly finding maximum and minimum values. They can also be referenced in formulas for mathematical operations.

​
Formatting

Number fields support three formatting types, which users can choose according to their needs.
Displayed as regular numbers, such as 1, 2.0
Displayed with a given currency symbol, such as $1.00
Displayed in percentage format, such as 1%. Note that the stored value for 1% is 0.01, for 100% is 1, and percentages can exceed 100%
Set Formatting

​
Precision

The product provides 6 precision levels for users to choose from, ranging from integers to five decimal places. Set Precision

​
Display Modes

Number fields currently have 3 display modes.
No special display mode, simply presents the number itself in the cell.
Users can choose to display a ring chart, with options to set target value, chart color, and whether to show the number.
Users can choose to display a bar chart, with options to set target value, chart color, and whether to show the number.
Set Display Mode Formatting can be used not only in number fields but also in formula fields, rollup fields, and references. For details, please see Formatting