Alteryx Designer Desktop Discussions

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

column has (-ve and +ve#'s), %'s, and $ amounts

soniam
5 - Atom

Hello!! hope everyone is doing well!!

 

I have a value column that has (-ve and +ve#'s), %'s, and $ amounts but everything for now is showing as a number and I would like to convert them appropriately before I can create a visual. Appreciate the help!

2 REPLIES 2
mceleavey
17 - Castor
17 - Castor

Hi @soniam ,

 

can you post some representative data so we can help?

 

M.



Bulien

apathetichell
19 - Altair

two options - you can convert/make a new string column and format as you choose or you can format inside of the table tool. Percentages work fine there - getting your negative numbers exactly as you want can be problematic. I usually go the string route and keep it as a separate column so if I need to do any conditional value-based formatting I can do it on the nondisplayed original numeric column...

Labels