Decimal fields
Decimal fields accept and contain fixed-point decimal numbers. Real fields and decimal fields differ in the following ways:
- Real numbers are inherently defined to be approximations, and decimal numbers are defined to be exact.
- Decimal numbers can have greater precision.
- The administrator has control over the fractional portion in a decimal field.
The total number of values in a decimal field can be as many as 28 places long. This number includes the decimal places (up to 9) that you define in the Precision field. You can control the precision of the number by defining where the decimal point is placed. Decimal fields appear right-justified. Decimal, digit grouping, and negative sign symbols are based on the locale specified in the user preferences. If no user preference for locale exists, user environment settings are used (for example, Regional Settings Properties in the Windows Control Panel).
You can use decimal fields to process statistical information in reports.