SOLVED
Convert to number
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Bhavani_A
6 - Meteoroid
‎10-10-2019
02:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Labels:
- Labels:
- Common Use Cases
3 REPLIES 3
wdavis
Alteryx Alumni (Retired)
‎10-10-2019
02:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
ACE Emeritus
‎10-10-2019
02:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
5 - Atom
‎07-07-2020
08:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
