3 Replies Latest reply on Nov 10, 2017 6:11 AM by shaheen.haque.1

    Dynamically Changing Number Format.




      I have data starting from thousands to Millions. I have display them in Millions. Problem is when I am displaying the data in Millions, the number that are in thousands are displayed as 0.0M or 0.6 M which does not make sense. Is it possible to somehow manipulate and tell tableau that if the number is greater than Million than display in Millions else in Thousands. I hope I am making sense here. In the  image here 4.7M,2.7M,1.M are fine but I need the lower number to be displayed in thousands. I am attaching a dummy tableau 10.2 version.  Thank you so much for help.