WPS Percentage Field on macOS: Introduction

WPS Percentage Field is a numeric field type in Smart Table data tables that displays values as percentages; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the index
Membership-related items	0	All listed tasks are available directly

About This Feature

Overview

Percentage Field is a built-in field type for Smart Table data tables in WPS Office for Mac. It is used to enter and display values in percentage format and supports related display settings and data management.

Core capabilities include:

Create a percentage field for completion rate, growth rate, share, and similar scenarios.
Adjust number formatting in field settings to control how percentages are displayed.
Use the field in filtering, grouping, and related table analysis.
Review and correct the field type after importing data from Excel.

Typical use cases include project progress tracking, growth analysis, task completion reporting, and ratio-based data display.

System Requirements

Item	Requirement
Operating system	A Mac device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office for Mac
Network	Creating and editing local fields does not require a constant connection; sign-in, sync, and collaboration work more smoothly with internet access
Other	You need access to a Smart Table data table and permission to edit fields

Source: System requirements for WPS Office

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office for Mac, open a Smart Table data table, and confirm that Add Field and Field Settings are available

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Smart Table supports adding a Percentage Field and adjusting its number format in field settings. The field can continue to be used for filtering, grouping, and statistics.	Microsoft Lists supports column formatting, and number columns can use data bars and related display options, but the official guidance focuses more on list column presentation than on a dedicated percentage field type.	Google Sheets supports applying percentage formatting to cells and also supports custom number formats for display control.	Notion database number properties support the `percent` format for percentage display.	Adobe Acrobat supports percentage-related formatting in PDF form fields, but this is oriented to PDF form input and display rather than structured table field management.
WPS Advantages	Advantage: WPS lets you create a percentage column directly as a field type in a Smart Table and continue using it for filtering, grouping, and statistics in a structured table workflow.	Compared with WPS: Microsoft's official page emphasizes column appearance and formatting rules more than a dedicated percentage field workflow in a structured data table.	Compared with WPS: Google Sheets focuses on cell formatting, with less emphasis on field-level structured table management.	Compared with WPS: Notion supports percent display, but the official material mainly describes property formatting rather than a spreadsheet-style field workflow.	Compared with WPS: Adobe is better aligned with PDF form field formatting than Smart Table field design.
Official Source	—	Format a column in Microsoft Lists	Format numbers in Google Sheets	Property Schema Object	Format form fields in Acrobat

Overall Conclusion
If you need to maintain completion rates, shares, or growth rates as structured table data, WPS Percentage Field fits a field-based workflow more closely. Other products also support percentage display, but their official guidance is centered more on cell formatting, database property formatting, or PDF form formatting.

Use Cases

No.	Scenario	Suitable for	Main challenge	How it helps
1	Project completion tracking	Project managers and team leads	Progress data needs a consistent percentage view	Create a Percentage Field to record completion rates
2	Sales growth analysis	Operations and sales analysts	Growth data needs clear comparison	Store growth rates in a Percentage Field and filter records
3	Budget share tracking	Finance and admin teams	Share values are hard to manage consistently	Use a Percentage Field for budget ratios and group records
4	Survey result summaries	Research and marketing teams	Ratio results need a unified display format	Set a Percentage Field and adjust the number format
5	Excel import correction	Data coordinators	Imported columns may not match the intended field type	Review imported fields and change them to Percentage Field when needed

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic use of Percentage Field in Smart Table	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available with a broader feature range
Cloud storage	1 GB	20 GB
Advanced templates and more advanced tools	Partially limited	✅ Available
AI-related tools	Partially limited	✅ Available, depending on the plan

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
You mainly need to create and maintain Percentage Fields in data tables	Free	The feature guidance shows no membership restriction for the listed tasks
You also need more cloud storage, templates, or broader office features	WPS Premium	Better suited to frequent work, cross-device use, and expanded feature needs

WPS membership center: Subscribe now