ToNumber converts String to V_Wstring again

I tried to convert a string number into numeric one using ToNumber, however, I saw that the function converted the targeted String into V_Wstring . I did smth wrong yet I am not aware of that mistake. Any solution or guidance? Thank you

Pic_1.PNG

Pic_4.PNG

Pic_2.PNG

Pic_3.PNG

Transformation

Accepted answers

JosephSerpis

Hi @Lego in the formula tool you need to change the drop down "Data Type" to a numeric data type such as double. Its set on V_Wstring in your pictures.

All comments

JosephSerpis

Hi @Lego in the formula tool you need to change the drop down "Data Type" to a numeric data type such as double. Its set on V_Wstring in your pictures.

Lego

Thank you @JosephSerpis . I did not pay attention.))

Flo_G

Hi @JosephSerpis I have the same issue, in my case the dropdown for data type is greyed out. My formula:

ToNumber(Trim([field],'%'))/100

Any thoughts on how to fix this?

Thank you in advance!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703