1 Reply Latest reply on Apr 16, 2018 9:48 PM by Shinichiro Murakami

    Rounding of percentages to make up 100 in quick table calc

    Jason CSW

      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.

       

      Thank you