This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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