community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Data Formatting

Meteor

Hi all,

 

I am running into an issue when trying to format my data.

 

I have values in fields I would like to convert to currency with comma-separators (i.e. 10000 to $10,000) and another field that I need to convert into a percent (i.e. .567 to 56.7%).

 

I have attached my workflow and source data. I have attempted going through several help links in the Alteryx community and have not had any luck with using the ToString formulas, so hoping to figure out if it is just a data formatting issue in my workflow that I'm unaware of.

 

I also need to sort in ascending order on "Estimate". My end goal is to put it in a table and send it in an email.

 

Thanks in advance!

Aurora

Hi @aralbrecht 

 

The fields in your formula are numeric types

 

Formula.png

 

Unlike in  Excel, you can't change the display format of numeric columns.  If you want to include "$" or "%", you'll need to either change the type of the existing columns or change the formula to create new string columns

 

Dan

Highlighted
Meteor

Hi Dan @danilang , I tried changing them to String, but still no luck. Any idea what might be causing the issue? I've reattached the workflow now that all are strings, thanks.

 

clipboard_image_0.png

 

 

Alteryx Certified Partner

Hi @aralbrecht you need to create a new field that is a string filed then add your currency sign to your numeric field the attached showcases this.

Meteor

@JS420 that works, thanks!

Labels