Last Modified Date: 25 Oct 2022
Environment
Tableau DesktopResolution
The below calculation can be reviewed in the attached workbook Formatting in Millions.twbx.Create a calculated field similar to the following:
IF SUM([field]) >= 1000000 THEN "$" + STR(ROUND((SUM([Invoice])/1000000),1)) + "M"
ELSE "$" + STR(ROUND(SUM([field]),0))
END
Then add the new calculated field to the Label card. This calculated field returns a string, meaning it will work for labels but cannot be used in any numerical calculations or for totals.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials