Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
SOLVED

Convert to number

Highlighted
5 - Atom

How can convert the below values to numbers?

clipboard_image_0.png

Highlighted
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

Highlighted
16 - Nebula
16 - Nebula

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.

 

Highlighted
5 - Atom

Hi,

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

Sales PersonTotal SalesProduct
Jason25995Car
Maria5547Motorcycle
Mike2751Home

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

Appreciate for your help

Labels