In this article
Here you can specify how the numbers in the table are to be displayed. You can increase the number of decimal places displayed to reduce the effects of rounding and thereby increase the accuracy of the displayed data. The tab contains two pages:
General page:
- Format - specifies the format for the numbers displayed in the table.
- Default - the numbers are displayed without any formatting.
- Currency - if you wish to display the numbers as a currency, select this option then specify the desired currency symbol.
- Time Span - the numbers in the table will represent units of time. You can then also specify what the unit is to be and how the numbers are to be interpreted; Days, hours, minutes, seconds or milliseconds. The numbers will always be displayed in the format HH:MM:SS,M.
- Use 1000 separator - check to show the designated 1000 separator when appropriate in the table.
Decimals page:
These fields allow you to define different decimal place values for distributions (e.g. count and percent), the Totals rows and columns, and numeric statistics (e.g. average), For each cell type, specify the number of decimal places you want to display after the point. Enter a whole, positive numeric value (integers greater than or equal to 0) in the fields. Note that you can also adjust the number of decimal places presented by clicking the Increase and Decrease Decimals buttons in the table toolbar (go to Table Toolbar for more information).
For the Decimals settings, the following rules apply:
- The "statistics" setting has a higher priority than "totals".
- If either of the "totals" or "statistics" settings are not set, then the "distributions" setting will be used by default.
- Any local "decimal" setting in a table header overrides the table settings.