WPS Percentage Field on macOS FAQ

Last updated:July 21, 2026

When using Percentage Field, the most common questions focus on field changes, filtering and grouping, and import recognition; this section includes 3 frequent questions and a short glossary.

FAQ

Can I change a Percentage Field to another field type after creating it?

  1. Right-click the target field and open Field Settings.
  2. Select Change Field Type.
  3. Choose the new field type and save the change.
  4. Check whether the existing data is compatible before you confirm the change.

Can a Percentage Field be used for filtering and grouping?

  1. Open the filter or grouping feature in the data table.
  2. Select the Percentage Field from the field list.
  3. Set the condition or grouping method.
  4. Review the result and adjust it if needed.

How do I keep the Percentage Field type correct when importing from Excel?

  1. After importing the Excel file, review the field types recognized by the system.
  2. If the target column is not recognized as a Percentage Field, open Field Settings.
  3. Change the field type to Percentage manually.
  4. Save the setting and confirm that the display and result match your expectation.

Glossary

TermDefinition
Percentage FieldA data-table field type that displays numeric values as percentages. It is suitable for completion rates, shares, and growth rates.
Number FormatA setting that controls how numeric values are displayed, including percentage style and decimal places.
Field SettingsThe settings entry used to adjust field properties, display format, or field type.