Extracting characters 2 and 3 from my V_String as doesn't recognise %

Question

Hi everyone! This is probably really simple but I can't seem to figure out! As Alteryx doesn't like % I am trying to extract characters (which are numbers in this case) 2 and 3 from my data. To explain, I brought in a % from another file into my main dataset, in the file it stated 60%, but when I brought into my main data set, it's coming out as 0.600328947368421 I tried to change the type to String, Float etc and still got the same result. So my thinking is now I can extract characters 2 & 3 (60 in this example) so at least I will know it is representing 60%. I hope that makes sense and any help would be very much appreciated :)

Amit_G_Limbasia · Accepted Answer

Dear @binsell,

You can simply try by converting into number and Multiply by 100 so it come as % then you can convert into string and add % sign that might help you !

For your case You can round like this also