Loading

Formatting Large Amounts With Millions Marks ($1 M) While Still Displaying Amounts Less than a Million

Date de publication: Mar 24, 2026
Description
Unable to format text to display millions and lower amounts simultaneously.
Résolution
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.
Numéro d’article de la base de connaissances

001473402

Pièces jointes

Formatting in Millions.twbx

186 KB

 
Chargement
Salesforce Help | Article