Loading

Displaying Multiple Formats for a Single Measure in the View

Udgivelsesdato: Feb 24, 2026
Opgave
How to display a measure using different formatting depending on the associated dimensions.
Trin

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 

Yderligere ressourcer
It will usually be necessary to convert measures into strings in order to achieve this result.

Vidensartikelnummer

001458080

Vedhæftede filer

Sample of Format.twbx

20 KB

 
Indlæser
Salesforce Help | Article