6 Replies Latest reply on May 1, 2014 8:22 AM by Tusal patel

    Color Conditioning and rounding

    Jackie Klein

      Hello,

      I am trying to figure out how to tell tableau to round to the first decimal place first and then apply the color conditioning.  For example, in the attached sample file I have a calculated field "Profit Ratio Goal".  I want the color to be green for everyone in the Furniture category if the value is >= 20.0% (rounded to the first decimal place).  As you can see, Vicky Freyman's value is 20.0% and her color should be green, but instead is showing as yellow.  Please, please tell me there is a way to do this in tableau.

       

      Thanks,

      Jackie