Loading

Displaying Multiple Formats for a Single Measure in the View

Publiceringsdatum: Feb 24, 2026
Uppgift
How to display a measure using different formatting depending on the associated dimensions.
Steg

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 

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

Knowledge-artikelnummer

001458080

Bilagor

Sample of Format.twbx

20 KB

 
Laddar
Salesforce Help | Article