2 Replies Latest reply on Dec 12, 2016 2:34 AM by Mahfooj Khan

    Format Percent like Excel Custom ##0.0%_);[Red](##0.0%)

    Greg Mooney

      Would like to know how to have a calculated field be formatted like this:

       

      This is a snapshot from Excel. I'm not worried about the background color. Just the formatting of the positive versus the negative numbers.

       

      I once did this in Tableau and I think it had to do with setting up 2 different calculated fields like Sale Growth Positive, Sales Growth Negative and then having the displayed measure do an if statement with those 2?

       

      Any help is appreciated.