Alteryx Designer Discussions

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

conditional string value

pokhan27
8 - Asteroid

Hi Expert 

 

i am trying to get the value "-" if the cell is Null or 0. and have 0% based on the calculation

Desired output

pokhan27_0-1632509708972.png

 

I want to insert the conditional in following formula, after data cleansing i already have Null values as 0 but now i need to insert "-" to all ) values. 

pokhan27_1-1632509774271.png

 

6 REPLIES 6
binuacs
10 - Fireball

can you provide some sample input values and expected output values?

mnmemilymnm
7 - Meteor

Would an IF THEN ELSE formula work? I'm thinking something like:

 

if([32% /68% OTC and Appt Data]*100=0)

then "-"

else tostring(([32% /68% OTC and Appt Data]*100),0)+'%'

endif

pokhan27
8 - Asteroid

Input: 

OTC DataAppt DataOTC and Appt Combined 
119%168%152% 
39%90%73% 
104%90%94% 
99%73%81% 
39%47%44% 
55%46%49% 
%%% 

 

Output data 

OTC DataAppt DataOTC and Appt Combined
119%168%152%
39%90%73%
104%90%94%
99%73%81%
39%47%44%
55%46%49%
0%0%0%

 

 

atcodedog05
21 - Polaris

Hi @pokhan27 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1632748804317.png

 

Hope this helps : )

pokhan27
8 - Asteroid

always you are a life saver thank you. 

atcodedog05
21 - Polaris

Happy to help : ) @pokhan27 

Cheers and have a nice day!

Labels