What it means
Notes expected a number but got text, either from the user or inside a formula.
Common causes
- Letters or symbols typed into a number field or number setting
- A formula doing arithmetic on a text field
- Imported data where numbers were stored as text
Quick fixes
- If you are a user, re-enter the value as a plain number
- In formulas, convert with
@TextToNumber and check the result with @IsError
- Fix the field type on the form, or clean up the stored values with an agent
Disclaimer
The errors, causes and fixes on this site are carefully researched, drawing on HCL documentation and 28 years of hands-on Domino and Notes experience. Every environment is different, though, and a solution that works in one may not be right for yours. Exact wording can also vary between Domino and Notes versions.
This information is general guidance only and is provided without warranty of any kind. Always back up your data and test changes on a non-production system first. To the extent permitted by law, Bruinsma Services Pty Ltd accepts no responsibility or liability for any loss, damage, downtime or other consequence arising from use of this information. For advice specific to your environment, please contact me.