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 to that shown in the NET or SUM on a table.
For example, say we have the following table shown to 13 decimal places:
In Displayr, rounding to 0 decimal places shows:
Whereas if manually adding up the numbers you would get the incorrect result of 99%.
A Displayr document
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 change the number of decimal places of precision in a table:
- Select the table
- In the Object Inspector, use Properties > APPEARANCE > Decimals and choose either of the two buttons.
There is no perfect approach to rounding. The approach used in Displayr is the industry standard.
How to Remove Decimals in a Table Without Rounding
Article is closed for comments.