Loading

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

Дата публикации: Mar 24, 2026
Описание
Unable to format text to display millions and lower amounts simultaneously.
Решение
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.
Номер статьи базы знаний

001473402

Вложения

Formatting in Millions.twbx

186 KB

 
Загрузка
Salesforce Help | Article