We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

To string conversion issue 345678.34343343 to $ 345,678.34

subhajits11
8 - Asteroid
‎06-12-2020 08:22 AM

"$"+tostring([Base Pay],2,1)
not giving proper result.

subhajits11_0-1591974968953.png

 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
JosephSerpis
17 - Castor
17 - Castor
‎06-12-2020 08:34 AM

Hi @subhajits11 my only suggestion is to check the date type of your Base Pay field as it coming from a CSV it might be string field hence why the formula is not working. You can see the data type by using either a select or field info tool. 

Reply
Live Office Hours
Labels
Top Solution Authors
View All