Loading

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

Data pubblicazione: Mar 24, 2026
Descrizione
Unable to format text to display millions and lower amounts simultaneously.
Risoluzione
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.
Numero articolo Knowledge

001473402

Allegati

Formatting in Millions.twbx

186 KB

 
Caricamento
Salesforce Help | Article