SOLVED
Format number with currency & decimal to be part of a string
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
stephenslaughter
6 - Meteoroid
‎03-23-2022
10:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying to figure out how to format a number (double) into currency and then add as part of a string. Would this be a formula, regex, or is there an easy way to quickly convert a number to currency?
Program | Year | Cost | Output |
Aaaa | 2020 | 500.5 | Aaaa (2020) $500.50 |
Bbbb | 2020 | 600.6 | Bbbb (2020) $600.60 |
Aaaa | 2019 | 7000 | Aaaa (2019) $7,000.00 |
Aaaa | 2019 | 80 | Aaaa (2019) $80.00 |
Bbbb | 2019 | 9090.99 | Bbbb (2019) $9,090.99 |
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
- Expression
- Output
4 REPLIES 4
allwynthomas24
11 - Bolide
‎03-23-2022
11:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @stephenslaughter,
Please check the attached workflow and confirm whether it matches your current requirements.
Thanks & Regards,
Allwyn Thomas
TonyA
Alteryx Alumni (Retired)
‎03-23-2022
12:08 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A couple of people have posted other solutions here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-Format-Currency/td-p/828144
TonyA
Alteryx Alumni (Retired)
‎03-23-2022
12:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎03-23-2022
01:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks, TonyA!
