Quantity

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
  • English 
Period (.) 2.5 Comma (,)  1,000,000
(one million)
  • Dutch
  • Greek
  • Indonesian
  • Portuguese
  • Romanian
  • Spanish
  • Turkish
Comma (,)  2,5 Period (.) 1.000.000
(one million)
  • Arabic
  • Burmese
  • Farsi
  • Hungarian
  • Pashtu
  • Polish
  • Russian
  • Slovak
  • Ukrainian
Comma (,)  2,5 Space ( )

1 000 000
(one million)

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.

Next item
Subform