Forum Discussion
Metric Switch Formatting Error
I just figured out a way to resolve it after trying every possible way. I was able to create a third metric switch statement that did the subtraction and formatting in the last metric switch used. Simple = Difficult haha
Thank you for all your help and suggestions! Radhika2605 Fowmy
Fowmy Thanks for the response!
Since Metric Switch turn all measures in it to default format "text", I have left Cancellation % and Production % format as "General" in the original meausre. The only place I format them to % is in the Metric Switch. Even if I changed the format in the original measure, the switch statement removes it and turns it to text.
Super UserAnonymous
When you use FORMAT, the result becomes text, you cannot do calculations on that.
Fowmy Ahh, I did not know that, I thought only the metric switch changed the format of the measures. And if I apply the format to the measures, they should be able to subtract together. Which obviosly it makes sense why its throwing that error now. Thank you.