Percentage string to numbers

[wenyg]

Hi

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

[SPetrie]

In your example, I would use a multi-field tool set to change output types to double and this formula.

tonumber(replace([_CurrentField_],"%",""))/100

[wenyg]

Thanks,

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

[caltang]

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.

[ckussoy]

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