Required the data in "Double format"

[Maheshp]

Hi Team,

I have a value in below format but when I am using the SELECT tool to double the value, it gives us a result like 14,1 " mean giving a value before comma. can you please guide.

14,131.81

1,721.31

Regards,

Mahesh

[JosephSerpis]

Hi @Maheshp you will need to remove the comma as Alteryx will assume it's a string and the behaviour you mentioned is expected with the select tool. You can use a  a formula such as Replace(Column,',','') to get the result you expect.

[aatalai]

similar to @JosephSerpis , but using the multi field tool so you could change the data type in the same tool

tonumber(Replace([_CurrentField_], ",", ""))

[SPetrie]

I agree with @aatalai , especially since that tool can handle multiple columns at a time and change the data type all at once. Only change I would suggest  would be tonumber([_CurrentField]).

The tonumber formula assumes commas as the thousands separator as a default, so replacing them isnt necessary for this situation. You would only need a replace for extra characters like dollar signs.