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
Check out the Formula Handbook template!