1 Reply Latest reply on Oct 23, 2012 7:32 AM by Kristofer Still

    How do I preserve number formatting when I am converting a number value to a string?

    Kristofer Still

      I have a dashboard where I want a set of measures to be displayed in a very specific way and because I don't like how it looks as a Tableau table I tried to concatenate it together as a string field. However when I convert my values to strings the number formatting isn't preserved and I end up with scientific notation and long strings of decimals.  Is there a way within my formula to preserve the number formatting I have the field set to?


      This is the string I want:


      To Date              

      $74.9M (67%)    


      Here is the formula:


      STR(SUM([Sales]))+" "+STR(([% of Forecast]))


      And what Tableau returns:


      To Date

      74.89762e+006 0.666666666


      [Sales] is set to 0.0M  and  [% of Forecast] is a custom percentage, 0 decimal with the ()'s  - (0%)