8 Replies Latest reply on Sep 19, 2016 7:19 AM by Mark Fagan

    Rounding down if <=68.49% to 68% and up if >=68.50% to 69%

    Mark Fagan

      I have a calculated field to validate if a store percentage met or exceeded the district managers percentage then I applying green color if it did and blue if it did not.

       

      Store             =     68.80%

      D Manger     =      69.47%

       

      So both percentages should be calculating at 69%

       

      How can I get tableau to account for the rounding this to meet this requirement?

       

      I have looked through the forums and found floor/ceiling but cannot seem to find what I need to produce the color .

       

      Thanks in advance for any direction!

       

      -Mark