Hide When Formula

Does anybody understand why the following hide when formula is not working? I have two roles assigned to a dB and have enforced ACL across all replicas and want the user to see a button if they are assigned to either role but button is only visible if they are assigned both roles.Formula is as follows.

@IsNotMember(“{IT]”;@UserRoles) | @IsNotMember(“[VisSystemBoard]”;@UserRoles)

Thanks in advance for any advice given.

Subject: Hide When Formula

Try this:@IsNotMember(“[IT]”;@UserRoles) & @IsNotMember(“[VisSystemBoard]”;@UserRoles)

Subject: RE: Hide When Formula

Thanks for your help it now works OK, only problem is I dont understand why it works.My understanding is that (|= or) so if either role 1 or role 2 is met the condition is true but (& = and) so both conditions must be met for the result to be true.

Subject: But you are writing a Hide formula…

I usually find it a lot easier to write them like this…

Show := @IsMember(“{IT]”;@UserRoles) | @IsMember(“[VisSystemBoard]”;@UserRoles);

!Show

Subject: Hide When Formula

The condition may need extra “( a OR b )” instead of “a OR b” ??