Alteryx Designer Desktop Discussions

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

Data conversion using functions

dawid_nawrot
9 - Comet

I'm trying to explore using functions more to avoid using multiple auto-field and select tools. 

 

Basically from  2.3456 I would like to convert it to decimal and then add a string at the end, for example 2.35%, so I'm using Formula tool but I want to do this in one line. Would be a waste of space to do this field as Fixed Decimal and then create another field using another Formula..

3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus

Try:

 

ToString([numericfield],2)+"%"

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
dawid_nawrot
9 - Comet

I figured it out a minute after posting.. Need to be more patient next time, but I'll leave the thread for future generations!

MarqueeCrew
20 - Arcturus
20 - Arcturus

Thanks for the distraction to my last minute Christmas shopping!

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels