Decimal

This article explains how to create and use a Decimal field.

The Decimal field is a numerical field used to store decimal values. It is commonly used for data such as salary, price, or other values requiring fractional precision.

NocoDB supports up to 8 digits of precision.

Create a Decimal field

  1. Click the + icon next to the last field in your table.
  2. Enter a name for the field.
  3. Select Decimal from the list of field types.
  4. Configure the Precision setting (up to 8 digits).
  5. Toggle Show thousands separator to format large numbers with a thousand separator (e.g., 1,000.00 instead of 1000.00).
  6. (Optional) Set a default value for the field and add a description.
  7. Click Save field to add the field to your table.

Refer to the general guidelines on creating a field.

The default precision is set to 1 digit.

Cell display

The Decimal field appears as a numeric cell in the table, right-aligned for readability. Values are displayed with the configured number of decimal places. If the Show thousands separator option is enabled, large numbers will be formatted with a comma as the thousand separator.

Number field cell display