2 Replies Latest reply on Aug 6, 2018 1:24 PM by Deepak Rai

    How to round numbers and color code on Tableau?

    Mike Ann

      I  converted number to percentage and want see it in two decimal places and color code it.

       

      I have these three numbers

       

      -0.005%, 0.001% , -0.004%, 0.001%

      when i convert this into two decimal places, I get

      0.00%, 0.00%, 0.00%, 0.00%

      when I try to color code them , I get

       

      0.00%, 0.00%, 0.00%, 0.00%

       

      How can I make anything positve and above 0 green,

      less than 0 red and numbers that are 0.00% black