How to Use WPS Percentage Field on Windows

Use WPS Percentage Field with 4 how-to topics that cover field creation, property settings, filtering and grouping, and export or sharing; use the index below to jump to each task directly.

How-to Index

How-to Guide

1. Create a Percentage Field

Feature entry: Add Field button (+) on the right side of the header → select the Percentage field type

1. In the data table, click the Add Field button on the right side of the header.
2. In the field type list, find and select Percentage.
3. Enter the field name.
4. Click Confirm to finish creation.
5. Enter data in the new field as needed.

Success Criteria

• Interface result: A new percentage field column appears in the data table.
• Next action: You can enter data in the field and continue adjusting its properties.

Tips While Using

• Common mistake: If you choose another numeric field type, the display behavior may be different, so confirm the field type before creating it.
• Environment note: You need edit permission for the current data table.

2. Configure Field Properties

Feature entry: Right-click the field → Field Settings → Number Format

1. Right-click the Percentage Field that you created.
2. Select Field Settings.
3. In the settings panel, open the Number Format drop-down menu.
4. Adjust the percentage display format as needed.
5. Click OK to save the settings.

Success Criteria

• Interface result: The display style of percentage values is updated.
• Next action: Newly entered and existing values follow the updated format.

Tips While Using

• Common mistake: If you leave the panel without confirming the change, the new format is not saved.
• Environment note: The field settings entry must be used in an editable state.

3. Use a Percentage Field for Filtering and Grouping

Feature entry: Data table filter or grouping panel → select the Percentage Field

1. Open the filter or grouping feature in the current data table.
2. Select the Percentage Field from the field list.
3. Set the required filter condition or grouping method.
4. Apply the settings and review the result.

Success Criteria

• Interface result: Records are filtered or grouped by the Percentage Field.
• Next action: You can refine the conditions further to locate target records.

Tips While Using

• Common mistake: If the field values were not entered as expected, the filter result may not match your goal.
• Environment note: Create the field and enter usable data before applying filters or groups.

4. Export and Share Data That Includes a Percentage Field

Feature entry: Data table export or share entry

1. Open the data table that contains the Percentage Field.
2. Select the export or share feature.
3. Confirm the export range or sharing target as needed.
4. Finish the export or send the share.

Success Criteria

• Interface result: The data table is exported successfully, or the sharing action is completed.
• Next action: Recipients can view the related data content.

Tips While Using

• Common mistake: If you do not review field content before export, the output may not match expectations.
• Environment note: Sharing usually requires a network connection.