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

Highlighted
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