Loading

Displaying Multiple Formats for a Single Measure in the View

Julkaisupäivä: Feb 24, 2026
Tehtävä
How to display a measure using different formatting depending on the associated dimensions.
Vaiheet

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 

Lisäresurssit
It will usually be necessary to convert measures into strings in order to achieve this result.

Knowledge-artikkelin numero

001458080

Liitteet

Sample of Format.twbx

20 KB

 
Ladataan
Salesforce Help | Article