Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Data Formatting

aralbrecht
7 - 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!

4 REPLIES 4
danilang
19 - Altair
19 - Altair

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

aralbrecht
7 - 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

 

 

JosephSerpis
17 - Castor
17 - Castor

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.

aralbrecht
7 - Meteor

@JosephSerpis that works, thanks!

Labels