Hi all, I am currently using the quick table calc to calculate the percentage of the various age groups in the department. The problem is that when I format the percentages to 0 decimal place, the percentage in some of the stacked bar don't add up to 100% (it will only add up to 100% if I opt for at least 1 decimal place). Please see attached image.
I believe this is a display issue due to the rounding of the numbers. I seek your advice on how I can display the correct percentages with no decimal places in the stacked bar so that they add up to 100%. I saw on some threads that people recommend the use of the round or int formula but I am not sure on how to apply this on a quick table calc.