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?
- Right-click the target field.
- Open Field Settings or the related option for changing the field type.
- Select the new field type and confirm the change.
- 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?
- Open the view that contains the Percentage Field.
- Open the filtering or grouping feature.
- Select the Percentage Field as the target condition field.
- 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?
- Before importing, check whether the related column in Excel uses a consistent data format.
- After the import finishes, review whether the target column was recognized as the expected field type.
- If the result is not what you want, change the field type manually.
- If needed, clean up the source data format first and then import again.
Glossary
| Term | Definition |
|---|---|
| Percentage Field | A field type that displays numeric values as percentages, suitable for ratios, completion rates, and growth metrics. |
| Number Format | A setting that controls how numeric values are displayed, such as percentage style and decimal places. |
| Field Settings | The configuration area used to adjust a field name, type, or display format. |