Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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
20 - Arcturus

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

mnmemilymnm
8 - Asteroid

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
22 - Nova
22 - Nova

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
22 - Nova
22 - Nova

Happy to help : ) @pokhan27 

Cheers and have a nice day!

Labels