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!