Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Convert to number

Bhavani_A
6 - Meteoroid

How can convert the below values to numbers?

clipboard_image_0.png

3 REPLIES 3
wdavis
Alteryx
Alteryx

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
ACE Emeritus
ACE Emeritus

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.

 

zman53
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