SOLVED
Convert String to Double for Amount
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
Sheena_Mae
6 - Meteoroid
‎09-07-2022
11:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi!
I am new to Alteryx. I hope you can help me.
I have a field string for my amount "3,359.83-" , is it possible to convert this to "-3359.83" and make the field to double ?
or is it just "3359.83-" and make the field to double? Does Summing it up doesn't affect the total value?
Thank you.
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
- Transformation
- Workflow
2 REPLIES 2
grazitti_sapna
17 - Castor
‎09-07-2022
11:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Sheena_Mae , You can achieve this by using formula tool and select tool. Please take a look at the workflow I shared and accept my solution if it helps.
Thanks!!
Sapna Gupta
‎09-08-2022
12:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
