Convert to number

[Bhavani_A]

How can convert the below values to numbers?

[wdavis · Accepted solution]

Hi @Bhavani_A 

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.

[zman53]

Hi,

I am new to using Alteryx, I need your help by using table below, 

Sales Person	Total Sales	Product
Jason	25995	Car
Maria	5547	Motorcycle
Mike	2751	Home

by using IF condition like this, IF product = "Car" then Total Sales/25, I got error on the result.

Appreciate for your help