UPCOMING WEBINAR: The complete guide to analyzing NPS 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:
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%
Whereas if manually adding up the numbers you would get the incorrect result of 99%.
Requirements
Please note this requires the Data Stories module or a Displayr license.
- 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 the object inspector, use Appearance > Decimals and choose either of the two buttons.
Next
How to Remove Decimals in a Table Without Rounding