community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Convert to number

Atom

How can convert the below values to numbers?

clipboard_image_0.png

Alteryx
Alteryx

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

I would use a Multi Field Formula tool:

 

clipboard_image_0.png

 

With the expression similar to @wdavis 

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

 

Sample attached.

 

Labels