How do I make a pie chart with 100% of percentage of de data?
Hello! I am trying to make a pie chart, but the sum of the percentages is always 99% or 101% for example. How do I solve it? It seems it doesn't have a tool that corrects an uneven number.
Best Answer

Smartsheet would round the percentage off. There is a scenario where the value after the decimal of all numbers are less than 0.5 (in your example, 0.13, 0.15, 0.48 & 0.24), which would result in sum of percentage being 99%. In order to workaround this, you may want to derive the percentage by yourself in a metric sheet. For example,
After that, add the pie chart based on the figures you derived.
Answers

Smartsheet would round the percentage off. There is a scenario where the value after the decimal of all numbers are less than 0.5 (in your example, 0.13, 0.15, 0.48 & 0.24), which would result in sum of percentage being 99%. In order to workaround this, you may want to derive the percentage by yourself in a metric sheet. For example,
After that, add the pie chart based on the figures you derived.

Thanks a lot! Yes, I guess Smartsheet doesn't do that automatically, so I will have to do it manually.

Depending on the tool you're using and the number of decimal places displayed, the percentages might be slightly rounded. For instance, the sum of several slices might show as 99% due to rounding down on individual percentages.
If you have a category that wasn't included in the data used to create the pie chart, it wouldn't be represented by a slice. This could make it seem like the percentages don doublecheck your data to ensure all categories are accounted for.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 202 Industry Talk
 430 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!