The percent field is used to store numerical values displayed as percentages, i.e. numbers that are represented as fractions of 100. For example the number 0.45 represented as a percentage would be 45%. The field is intended as a general purpose field type that can be used to store any type of percentage, for example, the percentage of positive feedback on television shows or the percentage of people born with curly hair.

When you add the percentage field you get options to set the level of precision of the percentage that can be set to range from two up to six decimal places. You are also given the option to allow negative percentage values e.g. -45%.

In some cases, it may be better to store your percentage values as a Number with decimal and simply mark the column header as containing percentages. This could be useful if you're using the data to perform certain calculations.

Last updated