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?
- Right-click the target field and open Field Settings.
- Select the entry related to changing the field type.
- Choose the new field type and confirm the change.
- 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?
- Open the filter or grouping feature in the data table.
- Select the Percentage Field from the field list.
- Set the condition and apply it.
- Review the result and refine the condition if needed.
How can I make sure the Percentage Field type is correct when importing from Excel?
- After importing the Excel file, check the field types identified by the system.
- If the detected result is not what you need, manually change the target column to a Percentage Field.
- If necessary, adjust the original data format in Excel and import the file again.
- 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?
- Open Field Settings and check the current number format.
- Confirm that the entered value matches the current percentage display rule.
- If the display precision is not what you want, adjust the number format again.
- Save the change and review the field display result.
Glossary
| Term | Definition |
|---|---|
| Percentage Field | A data-table field type that displays numeric values as percentages and is suitable for ratios, completion rates, and growth values. |
| Field Settings | The configuration entry used to adjust field properties, including display format and related options. |
| Number Format | The display rule that controls how numeric values appear, such as percentage style and decimal places. |
| Filtering | A way to locate records quickly by applying conditions to field values. |
| Grouping | A way to organize records by field values for easier review and analysis. |