How to Use WPS Percentage Field on Windows

Use WPS Percentage Field with 2 how-to topics: create a Percentage Field and configure field properties. You can jump from the How-to Index to each section and complete the setup step by step. 2 items are available without membership and 0 items are membership-related.

How-to Index

How-to Guide

1. Create a Percentage Field

Entry: Click the + button on the right side of the header row, then choose the Percentage field type

1. In the data table, click the Add Field button on the right side of the header row.
2. In the field type list, select Percentage.
3. Enter a field name.
4. Click Confirm to finish creation.
5. Enter data in the new field according to your percentage data needs.

Success Criteria

• Interface result: A new Percentage Field column appears in the table.
• Next action available: You can enter data in the field and continue with filtering, grouping, or statistics.

Tips While Using

• Common mistake: If you choose the wrong field type, you may need to change the field type again or recreate the field.
• Data entry: It is helpful to keep one team-wide input standard for later analysis.

2. Configure Field Properties

Entry: Right-click the field, open Field Settings, then open 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. Set the display format for percentage values as needed.
5. Click OK to save the settings.

Success Criteria

• Interface result: The display format of percentage values updates based on your settings.
• Next action available: Later data entry and review can follow the same display style.

Tips While Using

• Common mistake: Before changing the display format, check whether existing data also needs to follow the same rule.
• Data consistency: In team collaboration, it is helpful to keep decimal-place rules consistent.