is there a way to ouptup a number as a percent to Excel? Example .15 to 15%,
Solved! Go to Solution.
Since the "%" character isn't a numeric value, this will have to be made as a string field. If the original field is called [Percent], create a new field (formatted as a string) using this formula:
tostring(([Percent]*100),0)+"%"
How do I get 1 sig fig to the right of the decimal point?
Did you adjust the formula to this:
tostring(([Percent]*100),0)+"%"
if so I get a Malformed Function Call
Oh, never mind. I guess it only works if you type the formula correctly.
Haha we've all been there. I did update the formula with the ",0" to specify 0 decimal places.
I'm glad the formula worked. Happy Alteryx-ing!