"Number" data types allow you to create fields in which you can enter numbers, usually to express a particular amount of money.
These data types can also be controlled to accept only certain forms of numbers, so that when a number that does not conform with the specifications is entered, it will be rounded to a number that does fit the proper format.
Creating Number Data Types:
After entering an appropriate name for the data type and selecting "number" from the "Type" drop-down menu, click "Save," and you will be presented with a window similar to the one displayed below.
In the table labeled "Number," you should fill out the fields as follows:
Minimum: In this field, you should enter the lowest number that you would like to be accepted by fields of this data type. Should you enter a number that is lower than the number specified here, it will automatically be replaced with this minimum number.
Maximum: In this field, you should enter the highest number that you would like to be accepted by fields of this data type. Should you enter a number that is greater than the number specified here, it will automatically be replaced with this maximum number.
Precision: The number entered here will determine how many decimal places the system will round numbers entered into fields of this data type to. For example, if you specify the precision as "2," and you enter "5.579" into the field, the system will round the number to "5.58."
Divisor(s): Here, you can enter numbers that you would like to require the numbers entered into fields of this data type to be divisible by. For example, if dealing with money, you might want to enter ".10" and ".25" (the divisors should be separated by a semi-colon ";"), so that all numbers entered are rounded to the nearest ten cent piece or quarter. If you were to enter "5.689," the system would round it to "5.70," so that it
would be a valid amount of money.
Round Type: In this field, you can select the method that you would like the system to use in rounding numbers to comply with the criteria specified above. If you select "nearest," the system will always round numbers entered into fields of this data type to the closest number that meets all of the specified criteria (no matter whether it is higher or lower). Otherwise, if you select "round up" or "round down," the system will round numbers to the
nearest number in the direction specified that meets all of the specified criteria (even if there is a closer number in the opposite direction).
In order to preview how the system will round numbers with the criteria you have specified, you can click on "Modify" at the bottom of the screen, and the "Examples Based On Current Settings" table will be updated to reflect the settings you have chosen.
Should you be happy with the way the system rounds numbers after looking at the "Examples Based On Current Settings" table, simply click "Done" at the bottom of the screen, and the "number" data type will be added to the "Available Data Types" list.
