WPS Percentage Field on macOS: Introduction

WPS Percentage Field is a field type in Bitable that displays values as percentages and lets you adjust number formatting; this guide covers 2 core tasks, with 2 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	2	Matches the number of rows in the How-to Index
Available without membership	2	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index
Version limit	None stated	Use the feature in currently available versions
Membership limit	None stated	The feature can be used directly

About This Feature

Overview

Percentage Field is a field type in WPS Office for Mac Bitable. It is suitable for storing completion rates, growth rates, ratios, and other values that need percentage-based display.

Core capabilities include:

Create a percentage field directly from the field type list.
Adjust number formatting in field settings.
Use percentage data in filtering, grouping, and statistics.
Keep the field data available for export and sharing workflows.

This feature is useful for project tracking, sales ratio records, growth analysis, and structured business tables.

System Requirements

Item	Requirement
Operating system	A macOS device that can run WPS Office
App version	It is recommended to use the latest version of WPS Office for Mac
Network	Local editing does not require a constant connection; sign-in, sync, and sharing features require network access
Other	You need access to Bitable and permission to edit fields

Source: System Requirements for WPS Office

Download & Installation

Before using Percentage Field, install WPS Office for Mac and open a Bitable to manage fields.

Item	Details
Official download	WPS Office Free Download
Installation method	Download the Mac installer and complete the setup as prompted
Post-install check	Open WPS Office, enter Bitable, and confirm that the Add Field entry is available on the table header

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	WPS Bitable supports creating a Percentage Field, adjusting number formatting in field settings, and using the field in filtering, grouping, and statistics.	Excel supports Percentage number formatting for cells and lets users adjust decimal places.	Google Sheets lets users format numbers through Format > Number, including percentage display.	Notion databases support number properties and formula-based numeric calculations; in a weak-equivalent scenario, they can be used for percentage-related results.	Acrobat form fields support Percent formatting for PDF form input and display.
WPS Advantages	Advantage: WPS creates a percentage field directly at the structured field level in Bitable. Distinct: the field can continue to be used in filtering, grouping, and statistics after creation.	Compared with WPS: Excel mainly applies percentage formatting at the cell level rather than as a Bitable-style field type.	Compared with WPS: Google Sheets focuses on cell formatting and offers less field-structured management in this scenario.	Compared with WPS: Notion is centered more on database properties and formula outputs than on spreadsheet-style field editing.	Compared with WPS: Adobe focuses more on PDF form entry and display than on structured table data management.
Official Source	—	Format numbers as percentages in Excel	Format numbers in a spreadsheet	Formula syntax & functions	Format form fields in Acrobat

Overall Conclusion

If you need to create a percentage field directly in a structured Bitable and continue using it for filtering, grouping, and statistics, WPS provides a more focused workflow. Excel and Google Sheets are closer to cell-formatting scenarios, while Notion and Adobe are better aligned with database formulas and PDF forms.

Use Cases

No.	Scenario	Suitable for	Main challenge	How Percentage Field helps
1	Project completion tracking	Project managers and team leads	Progress values are not easy to read at a glance	Display completion rates in a consistent percentage field
2	Sales ratio analysis	Sales and operations teams	Ratio data is hard to compare quickly	Store ratio values in a percentage field and review them with statistics
3	Growth rate tracking	Data analysts	Growth values are displayed inconsistently	Keep percentage formatting consistent across records
4	Post-import field cleanup	Table maintainers	Imported data may not match the expected field type	Create or switch to a percentage field before continuing work
5	Grouping and filtering management	Collaborative business teams	Percentage data is difficult to classify visually	Use the percentage field in grouping and filtering views

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Create and use Percentage Field	✅ Available	✅ Available
Enter data and adjust field formatting in Bitable	✅ Available	✅ Available
Advanced PDF editing and additional advanced tools	May be limited based on the product page	Includes more advanced capabilities
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
You only need to create and maintain percentage fields in Bitable	Free	The feature itself has no membership restriction in the available feature information
You also need more advanced office, PDF, or cloud storage features	WPS Premium	Premium includes broader advanced capabilities and higher cloud storage

WPS membership center: Subscribe now
If you only need Percentage Field, you can start with the free feature set.