Last Modified Date: 30 Jul 2020
AnswerUse a calculated field with IF/THEN conditions.
For example, as in the attacked 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"
STR([Number]*100)+"%" else STR([Number])
Additional InformationIt will usually be necessary to convert measures into strings in order to achieve this result.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials