Forum Discussion
michellepace
Resolver III
Resolver IIIHow to format result in switch statement?
Hello, In the screenshot below I give my user the abolity to compare months either as an actual value or as a %. The problem is that I do not know how to force a percent format should my user select...
Well, the short answer is: You can't do this unless you use the very newest feature that's only available through Tabular Editor called "calculation groups." Your only option right now is to create a new measure, only for display purposes, that will output correctly formatted values. However, the values will be TEXT, not real numbers. Such a measure should only be used in visualizations, not in calculations. For calculations you should use a measure that returns raw numbers.