WPS Percentage Field on Windows FAQ

Last updated:July 24, 2026

When using WPS Percentage Field, common questions usually focus on field type changes, filtering and grouping, and import recognition. This FAQ includes 3 common 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.
  2. Open Field Settings or the related option for changing the field type.
  3. Select the new field type and confirm the change.
  4. Before changing it, check whether the existing data may become inconsistent because of format differences.

Can a Percentage Field be used for filtering and grouping?

  1. Open the view that contains the Percentage Field.
  2. Open the filtering or grouping feature.
  3. Select the Percentage Field as the target condition field.
  4. Set the filtering conditions or grouping rules based on your business needs.

How can I keep Percentage Field recognition more accurate when importing from Excel?

  1. Before importing, check whether the related column in Excel uses a consistent data format.
  2. After the import finishes, review whether the target column was recognized as the expected field type.
  3. If the result is not what you want, change the field type manually.
  4. If needed, clean up the source data format first and then import again.

Glossary

TermDefinition
Percentage FieldA field type that displays numeric values as percentages, suitable for ratios, completion rates, and growth metrics.
Number FormatA setting that controls how numeric values are displayed, such as percentage style and decimal places.
Field SettingsThe configuration area used to adjust a field name, type, or display format.