Decimal Places

<< Click to Display Table of Contents >>

Navigation:  Administration > Options > Asset Options >

Decimal Places

This option allows you to set the number of decimal places to display in numeric fields (where possible).

All values entered in numeric fields are stored in the database with up to 4 decimal places.  You may not want to display all four decimal places on your list screens and reports, so you can designate the number of decimal places, from 1 to 4, that will display.

The following topics are discussed in this section:

Setting the Decimal Places Option

Changing the Decimal Places Option

Searching for Data with Truncated Decimal Places

 
Setting the Decimal Places Option:
 

1.From the Main screen, click Administration > Options.  The Options screen appears.
 

2.Highlight the Decimal Places option:

 

OptionsDecimalPlaces
 

3.In the text field, enter the number of decimal places you want to display.  You can enter 0 through 4.  The default setting is 2 decimal places.

 

4.Click the OK button when you are done entering information.

 

Changing the Decimal Place Option:

If you change the number of allowed decimal places to a great number (1 to 4, for example) any digits stored prior to the change will display with trailing zeros.  For example, if a value of 25.5 was stored when the Decimal Places option was set to 1, it will be displayed as 25.500 if the Decimal Places option is later set to 3.

If you change the number of allowed decimal places to a lesser number (4 to 1, for example) any digits stored prior to the change will be rounded.  For example, if a value of 25.5 was stored when Decimal Places was set to 1, it will be displayed as 26 if Decimal places is later set to 0.  (Values rounded for display at the currently specified number of Decimal Places will retain their original number of decimal places as stored in the database.)

 

Searching for Data with Truncated Decimal Places:

Keep in mind that your numbers are stored with up to four decimal places.  If you set the Decimal Place option to 1, but your numbers contain 4 decimal places, it will be helpful to search using all the decimal places.  For example, if you are searching for the numbers: 4.123, 4.134, 4.148 but the Decimal Places option is set to one decimal place showing, the Asset List will displays these numbers as 4.1, 4.1, 4.1.  If you are attempting to use the Find feature to search for a specific number, you can type in all decimal places, 4.123, for example to make your search easier. However, when they go into the Find, they will be able to see all the decimal places.