WPS Statistics Fields on macOS FAQ

Last updated:July 22, 2026

When using Statistics Fields, common questions usually focus on calculation methods, result adjustments, and field setup; this FAQ includes 3 common questions and a glossary.

FAQ

What calculation methods are available in Statistics Fields?

  1. Right-click the title of the statistics field.
  2. Select Field Settings.
  3. Open the Calculation Method options.
  4. Available methods include sum, count, average, maximum, minimum, deduplication, deduplicated count, and string concatenation.

Can I change a Statistics Field after creating it?

  1. Locate the statistics field you already created.
  2. Right-click the field title and select Field Settings.
  3. Choose a different source field, calculation method, or condition.
  4. Review the updated result in the field.

Why does the Statistics Field result look incorrect?

  1. Check whether the correct data table and field are selected.
  2. Confirm that the calculation method matches your goal, such as sum, count, or average.
  3. Review any conditions that may be filtering the result.
  4. If repeated values affect the result, try deduplication or deduplicated count.

Glossary

TermDefinition
Statistics FieldA field type in a multidimensional table that aggregates data from related records.
Relation FieldA field that connects the current record with records in another data table and provides the basis for aggregation.
Calculation MethodThe rule used by a statistics field to calculate results, such as sum, count, average, or deduplicated count.