WPS Percentage Field on Windows FAQ

Last updated:July 21, 2026

When using WPS Percentage Field, the most common questions focus on field type changes, filtering and grouping, import recognition, and display settings; this FAQ covers 4 common questions and practical steps.

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 the entry related to changing the field type.
  3. Choose the new field type and confirm the change.
  4. Before changing the type, check whether the existing data is compatible and back up the data if needed.

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 and apply it.
  4. Review the result and refine the condition if needed.

How can I make sure the Percentage Field type is correct when importing from Excel?

  1. After importing the Excel file, check the field types identified by the system.
  2. If the detected result is not what you need, manually change the target column to a Percentage Field.
  3. If necessary, adjust the original data format in Excel and import the file again.
  4. After import, review sample records to confirm that the display is correct.

Why does the displayed result look different from what I expected after input?

  1. Open Field Settings and check the current number format.
  2. Confirm that the entered value matches the current percentage display rule.
  3. If the display precision is not what you want, adjust the number format again.
  4. Save the change and review the field display result.

Glossary

TermDefinition
Percentage FieldA data-table field type that displays numeric values as percentages and is suitable for ratios, completion rates, and growth values.
Field SettingsThe configuration entry used to adjust field properties, including display format and related options.
Number FormatThe display rule that controls how numeric values appear, such as percentage style and decimal places.
FilteringA way to locate records quickly by applying conditions to field values.
GroupingA way to organize records by field values for easier review and analysis.