3 Replies Latest reply on Jun 5, 2018 5:17 PM by Okechukwu Ossai

    Excel Custom Format Woks in Excel But Not Tableau... Need >300%, <(300)% Else the Actual %

    John Adubufuor

      Hi Everyone,

       

      I've always been able to use custom formats I create in Excel in Tableau so the fact that I have not been able to use this one has me scratching my head.

      In short, I want to be able to format my measure to display >300% for anything (you guessed it) >300% and display <-300% for anything less then -300% and the actual % for everything else.

       

      Here is the custom format working in Excel along with attachments.

       

      [<-3]"<(300)%";[>3]">300%";0%

       

      If anyone can find a way to make this work in Tableau (or come up with an alternative that does not change my values in Tableau) I would be extremely grateful.

      Thanks in advance

      john