UPCOMING WEBINAR: Build it once. Use it again: Create reusable charts with AI By default, Displayr does not display all the decimal places and instead rounds the results. For example, 33.3333333333% is rounded down to 33%, and 32.5% is rounded up to 33%.
A consequence of not all the decimal places being shown is that if you sum up the numbers manually, you may often get a different result than that shown in the NET or SUM on a table.
For example, say we have the following table shown to 13 decimal places:
| US | 33.3333333333333% |
| UK | 33.3333333333333% |
| AU | 33.3333333333333% |
| NET | 100.0000000000000% |
In Displayr, rounding to 0 decimal places shows:
| US | 33% |
| UK | 33% |
| AU | 33% |
| NET | 100% |
If you manually add up the numbers, you would get the incorrect result of 99%.
Requirements
- A table of data.
Method
While you can control the number of decimal places displayed on the screen, there is no perfect approach to rounding. The approach used in Displayr is the industry standard. To see more info about Displayr's rounding approach, see What to Do When Displayr's Results Are Different Than Another Program's Results.
To change the number of decimal places of precision in a table:
- Select the table.
- In Properties
, go to Appearance > Decimals and choose either of the two buttons.