Alteryx Designer Desktop Discussions

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

How to add "%" to a value in a specific column

gagandeep_dhall
8 - Asteroid

Hi,

 

I am trying to add "%" to values in a specific column using tostring. but its giving me either a blank or a null value. Formulas being used:

 

tostring(([Completed]/[Total Completed Interactions])*100),2)+'%'

 

or 

 

tostring([Overall STP Rate])+"%"

2 REPLIES 2
Kenda
16 - Nebula
16 - Nebula

Hi @gagandeep_dhall 

 

Are the fields you're applying these expressions to string fields?

gagandeep_dhall
8 - Asteroid

Hi @Kenda 

 

Got it. It worked 🙂

 

Thanks a ton 🙂

Labels