8 Replies Latest reply on Oct 31, 2018 9:31 AM by wasseem el khatib

    Rounded Negative Numbers Showing As Positive

    wasseem el khatib

      In Tableau, when I am rounding some negative numbers, because of the rounding, it is making my numbers turn into a positive.

       

      i.e:

      when rounding to 2 decimals, its showing as positive, however, when rounding to 3 decimals, it is showing as negative. See below:

       

      2 decimals:

      3 decimals:

       

      I would like that when keeping the 2 decimal view, to show my number as (0.00) and not 0.00. 

       

      Please note that I am using the below as the number format:

      #,##0.000;(#,##0.000)

       

      Thanks

      Wasseem