Last Modified Date: 26 Nov 2019
ResolutionThe 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))
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.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials