A Percent field stores a number and shows it as a percentage: type 50 and the field shows 50%. Set the decimal precision, the separators and whether negative values are allowed; exports write the decimal form, such as 0.5.
Plan Availability | All plan types. |
Permissions | Administrators and Solution Managers: add, configure and delete fields in their solutions. |
Platform | Web |
Related Reading |
What does the Percent field do?
It holds a numeric value formatted as a percentage. Enter the whole number you want shown; there is no need to type decimals. For a plain number, use the Number field instead.
How do I add a Percent field?
Add it from Grid View or from a record.
From Grid View
Open the table in Grid View.
Select the + at the right end of the column headers, or open a column's drop-down menu and select Add Field to the Right.
Select Percent, name the field and set its options.
Select Add Field.
From Record View
Open a record.
Select the + beside an existing field (or Add new field to this Table at the bottom of the record).
Select Percent, name the field and set its options.
Select Add Field.
Which settings does it have?
Display Format: a preview of the value with the current settings.
Precision: 0 to 6 decimal places (2 by default, 1.00%).
Thousands and decimal separators: the separator format.
Allow negative percentages: allow or block negative percentages.
Display thousands separator: show or hide it.
Require an entry in this field: a record cannot be saved without a value.
Defaults and help text are set as for any field; see Default Text/Values in Fields and Adding Field Help Text.
What happens when I copy or export a value?
Copying from the interface gives the formatted text, for example 50%.
Exporting to CSV, Excel or Google Sheets gives the decimal form, for example 0.5, so calculations work in the spreadsheet.
Where can I use Percent values?
Saved views, Formula fields and Rollup fields all read Percent fields. Example: a Rollup on a student record averages the grades held as percentages on linked course records.
You can also show it with a Lookup or on Linked Record cards, and filter Count fields by it. Sort or group records by it, filter them (equal to, greater than, less than, is empty and more), highlight them with Spotlight and search them with Find.
Frequently asked questions
Why does my export show 0.5 instead of 50%?
Why does my export show 0.5 instead of 50%?
Exports write the decimal form of a percentage so spreadsheets can calculate with it. The interface and copied text show 50%.
How do I show two decimal places?
How do I show two decimal places?
Open the field settings and set Precision to 0.00.
Can a percentage be negative?
Can a percentage be negative?
Yes, when Allow negative percentages is on; turn it off to block negative entries.
What value does a formula read from a Percent field?
What value does a formula read from a Percent field?
The stored value. A Percent field shown as 10% holds 0.1, and formulas use 0.1. A Currency of 500 multiplied by a Percent of 10% returns 50; multiply by 100 when a formula should show the percentage out of 100.
Last verified 29 Oct 2026.