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.

Formula Not Providing a Value

jalizmaldonado
8 - Asteroid

Hi team, I hope all is well. 

 

At the moment, I'm trying to assign 1-6 "Level Results" based on conditional logic but for some reason, 5 out of the 6 formulas are not providing a value at all. 

 

Below are the parameters, workflow with formulas, and data. 

 

why.PNG

4 REPLIES 4
MarqueeCrew
20 - Arcturus
20 - Arcturus

@jalizmaldonado 

 

pic is too blurry for my eyes. 

but


[job code] Not In ("ddddd","fffff","zzzzzz")

 

 cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Qiu
20 - Arcturus
20 - Arcturus

@jalizmaldonado 

You OR is wrong, I think.

It should be something like

[Job code] !="T0622" or [Job code] !="M1023"
jalizmaldonado
8 - Asteroid

@Qiu  @MarqueeCrew Hi, just realized I didn't include the data or the workflow from this point.

Qiu
20 - Arcturus
20 - Arcturus

@jalizmaldonado 
Somehow I get what you need to do.

But can you check your data again, since I dont have any match even I check manually based on your cretiria.

Say the location as 4787 doest not exist.

Labels