7 Replies Latest reply on Jan 3, 2018 1:17 PM by TaRan Wilson

    Rounding Decimals

    TaRan Wilson

      I need help rounding my decimals to the nearest hundredth (or tenth). If you look in the image below, the CMS that is set to Waiting is at 0.00%. If it was truly at 0%, then it shouldn't appear on the chart. So I looked at the actual number for it and it is 0.0017%. Tableau is set to only two decimal places, so it's cutting the last two digits off, rather than rounding them to the nearest hundredth.  How can I round all of these to the nearest hundredth?

       

      decimal percentages.png