Data Formatting

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!

DataFormatHelp.xlsx

FormatHelp.yxmd

Workflow

Datasets

Developer

Developer Tools

Input

Settings

Output

Tips and Tricks

Common Use Cases

Best Practices

Help

Preparation

Expression

Accepted answers

JosephSerpis

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.

FormatHelp.yxzp

All comments

danilang

Hi @aralbrecht

The fields in your formula are numeric types

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

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.

FormatHelp.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703