Minor difference between percentage value in table and chart visual

[KarthikKumarstp]

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

[danextian]

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.

[KarthikKumarstp]

Sorry - Tried this and still seeing the same thing

Attrition % = ROUND(DIVIDE([Actual Attrition Count],[Actual Headcount]),4)

[danextian]

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.

[KarthikKumarstp]

This is even interesting!!