Formula Not Providing a Value

[jalizmaldonado]

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. 

 

[MarqueeCrew]

@jalizmaldonado 

pic is too blurry for my eyes. 

but

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

 cheers,

 mark

[Qiu]

@jalizmaldonado 

You OR is wrong, I think.

It should be something like

[Job code] !="T0622" or [Job code] !="M1023"

[jalizmaldonado]

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

[Qiu]

@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.