"Hide Object When" Strange behaviour

[infoweb]

Hi there,

 

I'm getting what seems to be some strange behaviour when I try to use the following calculation in the "Hide object When" option:

 

Products::type ≠ "Spare Parts" or Products::type ≠ "Repairs"

 

 

The Goal is to show the object if type contains either "Spare Parts" OR "Repairs" and hide it for any other option.

 

If I use either of the two options on their own the hide object works, When I use them together it permanently hides the object.ie: it is hidden even when type DOES equal "Spare Parts" or "Repairs"

 

Am I missing something really obvious here?

[eos]

Products::type ≠ "Spare Parts" or Products::type ≠ "Repairs"

Am I missing something really obvious here?

Every record is “not a OR not b” – "Spare Parts" ≠ "Repairs", and "Repairs" ≠ "Spare Parts" – but you want to hide your object on every record that is “not a AND not b”.

 

Use

Products::type ≠ "Spare Parts" AND Products::type ≠ "Repairs"

or reverse the logic as

NOT ( Products::type = "Spare Parts" OR Products::type = "Repairs" )

[infoweb]

That solved the issue.

 

I have to admit, I had to read your explanation a few times before I actually understood the logic, but it finally made sense.

 

Thanks eos.