When using WPS Data Table Numbers, the most common questions focus on display formatting, formula calculations, and field selection.
FAQ
What formats does a number field support?
- On Android, you can use a number field to enter numeric values.
- Number display formatting is not adjusted on mobile at this time.
- If you need integer, decimal-place, or thousands-separator display settings, handle them on desktop.
Can a number field be used in formulas?
- Yes, you can create or edit a formula field in the multi-dimensional table.
- Reference the number field directly in the formula.
- Save the formula to calculate the result.
What is the difference between a number field and a currency field?
- A number field is suitable for general numeric records such as quantities, counts, or scores.
- A currency field is more suitable for amount-based scenarios and usually includes a currency symbol.
- If you mainly need plain numeric values for calculations, use a number field first.
Glossary
| Term | Definition |
|---|---|
| Number field | A field type used to store numeric values such as amounts, quantities, or statistics. |
| Multi-dimensional table | A structured table format used for records and collaboration, with multiple field types. |
| Formula field | A field type that calculates or returns results by referencing other fields. |