I'm guessing that this Value metric is based off a parameter?
A calculated field can be created that gives each value its format, however, it will change the values to a string rather than a keeping it as a measure. For example,
when "StockOut" then str(sum([StockOut]*100) + "%"
when "Units" then str(sum(Unit))
Hope this helps!
Actually, I would need to keep them as Measures
I found something that could work in the following Link:
However, I dont know why the "rawsql_str" is not shown in my FUNCTIONS panel...