Convert to number

[abhavani]

How can convert the below values to numbers?

[wdavis · Accepted solution]

Hi @abhavani 

If you use a Formula tool and use the Replace formula to remove the commas from your numbers, you can then update the type of field to a numeric data type in a select field.

Your formula would look like Replace([Net Amount], ",", "") - This effectively just removes the commas

Let me know if this works for you.

Kind Regards

Will

[jdunkerley79 · Accepted solution]

I would use a Multi Field Formula tool:

With the expression similar to @wdavis 

THis allows you to correct the input and change type in one go

Sample attached.