Common questions about WPS Currency Field usually involve calculations, symbol changes, display format, and default values; this FAQ covers 4 frequent questions and practical answers.
FAQ
Can a currency field be used in calculations?
- Yes.
- A currency field is still a number field.
- The currency format mainly changes how the value is displayed.
- In formulas, summaries, or statistics, the field can still be used as a numeric value.
How do I change the displayed currency symbol?
- Right-click the target currency field header.
- Open Field Settings.
- Choose a new currency symbol from the Currency list.
- After the change, existing amounts update to the new display format.
Does changing decimal places affect the original amount?
- No.
- Decimal-place settings control display precision.
- The stored value and later calculations do not change because of display-format adjustments.
Why do new records already show an amount?
- This usually means the currency field already has a default value.
- Right-click the field header and open Field Settings.
- Check the content in Default Value.
- If you do not want a prefilled amount, clear the default value setting.
Glossary
| Term | Definition |
|---|---|
| Currency Field | A number field used to store amounts and display them in a currency format. |
| Currency Symbol | The currency marker shown with an amount, such as ¥ or $. |
| Decimal Places | The precision setting that controls how many digits appear after the decimal point. |
| Default Value | A preset value that is filled in automatically when a new record is created. |