Numeric

Numeric field types allow for the input and storage of numerical data. These fields are versatile, catering to various business needs such as financial analysis and inventory management.

Numeric fields are strictly for numbers, including integers and decimals like "12" or "3.1415". Any non-numeric characters are automatically filtered out. You can also set numeric range constraints to ensure inputs fall within a specified interval.

These fields are invaluable for organizing data, enabling swift sorting and filtering to identify maximum or minimum values. Moreover, numeric fields can be incorporated into formulas for mathematical computations.

Formatting

Numeric fields offer three formatting options to suit various requirements:

Number

Displays as a standard number, e.g., 1, 2.0

Currency

Displays with a currency symbol, e.g., $1.00

Percentage

Displays in percentage format, e.g., 1%. Note: A 1% is stored as 0.01, and 100% as 1. Percentages can exceed 100%.

Formatting options enhance data presentation, making it more accessible and meaningful. This feature is not limited to numeric fields but can also be applied to formula fields, summary fields, and references for comprehensive data manipulation.

Set Formatting

Precision

It offers six levels of precision, ranging from whole numbers to five decimal places, allowing users to select the level that best fits their data accuracy needs.

Display Modes

Numeric fields come with three display modes for additional visualization options:

Default

A straightforward display, showing the numeric value as is.

Doughnut Chart

Users can opt for a doughnut chart display, with customizable target values, color schemes, and numeric display options.

Bar Chart

Users may choose a bar chart display, also with options for target values, colors, and whether to show numbers.

These formatting and display features not only enhance the visual appeal of numeric data but also its utility, facilitating easier analysis and decision-making processes. See formatting for details.