Quantity fields store a real-valued number.
Quantity fields can accept positive or negative numbers, whole numbers, and fractional numbers with decimal points.
Design
Units
When adding a Quantity field, you can provide the “units” of the number. The units are displayed during data entry as an aid to the user.
Formatting
When entering numbers in data entry, the symbols used for the decimal seperator and the thousands separtor depend on the user’s current language.
For example, the number “two and a half” is written in most English-speaking countries as “2.5”, while in most French-speaking countries the decimal seperator is a comma, and so the same number would be written as “2,5”.
Languages | Decimal Separator | Decimal Separator Example |
Thousand Separator |
Thousand Separator Example |
|
Period (.) | 2.5 | Comma (,) | 1,000,000 (one million) |
|
Comma (,) | 2,5 | Period (.) | 1.000.000 (one million) |
|
Comma (,) | 2,5 | Space ( ) | 1 000 000 |
Writing script
ActivityInfo always uses Western Arabic Numerals (1, 2, 3) rather than Eastern Arabic Numerals (١,٢,٣), even when the language is set to a language that uses the Arabic script.
Eastern Arabic Numerals can be used in data entry, but will be automatically reformatted with Western Arabic Numerals.
Data entry
Desktop
Limits
Numbers are stored internally as 64-bit floating point numbers. The maximum value a double can have. The greatest maximum value that a double can have is 1.79769313486231570e+308d. The minimum value a double can have. The lowest minimum value that a double can have is 2.2250738585072014E-308.