I'm sure you all had this - You add a breakdown bar report with percentages, and when the underlying values are 1 and 7 you end up getting 13% and 88%... This means, when you add the displayed percentages, you get 101%! ! How do you deal with these?

I second the suggestion for a pie chart - your readers will know that a pie chart shows percentages of the whole and sum to 100%, and will often realize on their own there is rounding. When you see a stacked bar chart, you aren't going to necessarily know it is supposed to sum to 100%

Hi @alitokmen , Ideally it should add to 100%, Here in your case data may be correct and its adding to 101% or sometimes 99% is due to rounding off. Can you try adding decimal places (this can solve your problem) while +- 1% if due to rounding off doesn't affect.

"Breakdown bar" view in Reports and percentages: what to do when the sum is 101%?

"Breakdown bar" view in Reports and percentages: what to do when the sum is 101%? | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded