Hide When Question...driving me crazy!

Can someone please tell me why this formula is not working properly? If I break it down and have only the first @IsNotMember in the formula, is works fine. If I have only the second, it works fine. But together, it does note work! Users should see the action button if they are assigned a specified role, or named in one of the designated fields.

(@IsNotMember(“[PDLab]”:“[DbDesigner]”;@UserRoles) |

@IsNotMember(@Name([CN];@UserName);manager: Writer : Team_leader:Team_leader_Bkup:ApproverName_1 : ApproverName_2 : ApproverName_3 : ApproverName_4 : ApproverName_5 : ApproverName_6 :ApproverName_7 : ApproverName_8 :ApproverName_9 :ApproverName_10 ))

What am I missing? This is driving me crazy!

Thanks!

Subject: Hide When Question…driving me crazy!

Try this:

(@IsNotMember(“[PDLab]”:“[DbDesigner]”;@UserRoles) &

@IsNotMember(@Name([CN];@UserName);manager: Writer : Team_leader:Team_leader_Bkup:ApproverName_1 : ApproverName_2 : ApproverName_3 : ApproverName_4 : ApproverName_5 : ApproverName_6 :ApproverName_7 : ApproverName_8 :ApproverName_9 :ApproverName_10 ))

Did you spot the difference ?

Subject: RE: Hide When Question…driving me crazy!

Thanks, Tom,for your quick response. It is working…

Of course…a simple “&” instead of a “|”. My thought process however is that “&” requires both conditions to be true, where “|” would be one or the other.

Subject: RE: Hide When Question…driving me crazy!

You are right: & requires both conditions to be true. It works like this: You have a formula that says that you SEE something if:

something1 OR something2

To work out the formula for HIDING something then we reverse the logic.

However, the reverse of (something1 OR something2) is actually (!something1 AND !something2)

To express it logical formula:

!(A | B) = (!A & !B)

Hope this makes sense.

Subject: RE: Hide When Question…driving me crazy!

Thank you very much for the explanation. I would think I would know this by now!

Subject: DeMorgan strikes again…

http://lc.brooklyn.cuny.edu/LeftBarFiles/FromAboutLC/Core5Files/Logic/demorg.html

It works the other way 'round, as well;

!(A & B) = (!A | !B)

Subject: Additional tips on hide when formulas

I wrote an article a little while back with some useful thoughts on Writing better hide-when formulas. I hope it helps.

Subject: RE: Additional tips on hide when formulas

Thanks a lot Guys,U cleared a lot of confusion on the "hide-when’s " through this discussion.

Thanks