Percentage string to numbers

Question

Hi

How to force a V string data with percentage sign to numbers?

Weixin Image_20231017170609.png

ckussoy · Answer

Thank you! This question came up during my office hours with a student calculating bonus amounts into a multiplier.

caltang · Answer

Unfortunately, that's not possible. The "%" makes it a string. Alteryx reads numeric data as is, the inclusion of a "%" forces it to be a string.

So what @SPetrie did is the best way to handle that data. Unless you're willing to trade off the data type for its appearance, then there's no other way.

wenyg · Answer

Thanks,

I would still want it to be percentage sign like "78.88%" but the data type to be double/numeric