How to summarize related records in WPS on Windows after creating the field?

Right-click the title of the statistics field. Select Field Settings . Update the target field, calculation method, or filter conditions in the settings panel.

WPS Statistics Fields on Windows FAQ

Q: What calculation methods does Statistics Fields support?

Right-click the statistics field title and open Field Settings . Check the Calculation Method list. You can choose sum, count, average, maximum, minimum, deduplication, distinct count, and string concatenation.

When you use Statistics Fields, common questions usually involve calculation methods, field settings, and result display; the answers below can help you troubleshoot quickly.

FAQ

What calculation methods does Statistics Fields support?

Right-click the statistics field title and open Field Settings.
Check the Calculation Method list.
You can choose sum, count, average, maximum, minimum, deduplication, distinct count, and string concatenation.

Why did I create a statistics field but still see no result?

Confirm that the statistics field was created successfully.
Open Field Settings and check whether the target data table and field have been selected.
If you added filter conditions, confirm that related records meet those conditions.

Right-click the title of the statistics field.
Select Field Settings.
Update the target field, calculation method, or filter conditions in the settings panel.

Glossary

Term	Definition
Statistics field	A field type used to automatically summarize data from related records.
Relation field	A field that connects records or data tables with each other.
Filter condition	A condition that limits which related records are included in the summary result.