Last Modified Date: 30 Dec 2016
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.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials