Loading

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

Publiceringsdatum: Mar 24, 2026
Beskrivning
Unable to format text to display millions and lower amounts simultaneously.
Lösning
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.
Knowledge-artikelnummer

001473402

Bilagor

Formatting in Millions.twbx

186 KB

 
Laddar
Salesforce Help | Article