Loading

Displaying Multiple Formats for a Single Measure in the View

Дата публикации: Feb 24, 2026
Задача
How to display a measure using different formatting depending on the associated dimensions.
Действия

Use a calculated field with IF/THEN conditions.
For example, as in the attached packaged workbook, if you have a dimension, Metric, with values A B C and D, and want the measure to be formatted as a percentage with A and B, but a float with C and D, you would create the following calculated field: 
If [Metric]="A" or [Metric]="B" 
Then 
STR([Number]*100)+"%" else STR([Number]) 
End 

Дополнительные ресурсы
It will usually be necessary to convert measures into strings in order to achieve this result.

Номер статьи базы знаний

001458080

Вложения

Sample of Format.twbx

20 KB

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