Forum Discussion
Minor difference between percentage value in table and chart visual
Hello all,
I have a simple measure called Attrition %
Attrition % = [Actual Attrition Count]/[Actual Headcount]
Here is my issues
Same measure when i use table metrics I get 1.39% for february whereas I get 1.40% in the bar chart.
Thanks in advance for you help
4 Replies
Hi KarthikKumarstp,
That's rather odd. Can you try using the DIVIDE function isntead of / (which is a better practice by the way)? If that doesn't work, I would try to round the numbers to two decimal points or that would be four for percent.
Sorry - Tried this and still seeing the same thing
Attrition % = ROUND(DIVIDE([Actual Attrition Count],[Actual Headcount]),4)Try adding the attrition count as a tooltip to the column visual and then show that as a table. I would like to see the numbers.
