?

[xyz1]

.

[Anil_Babu_Samineni]

Does "member of" and "All_Generic_Account" are fields?

[xyz1]

.

[bramkn]

if(wildmatch(Member of, '*ALL_Generic_Accounts*')AND  (if(wildmatch(Role,'*NO_PWDEXP*') OR wildmatch(Member of,'*ALL_Generic_Accounts*') OR wildmatch(Controls,'*NA*'))

Something like this? having the first one that must apply AND 3 options with OR between em and brackets () arround em

condition1 AND (condition2 OR condition3 OR condition4)

[xyz1]

.

[sasiparupudi1]

May be like this

Count(

{

<["Member of]={'ALL_Generic_Accounts'},Role = {'NO_PWDEXP'}>

+

<["Member of]={'ALL_Generic_Accounts'},[Claimed/Unclaimed Account]= {'Has Manager'}>

+

<["Member of]={'ALL_Generic_Accounts'},Controls= {'NA'}>

}

[Accounts])

[Anil_Babu_Samineni]

May be this?

Count({<Role = {'*NO_PWDEXP*'}>+<[Claimed/Unclaimed Account] = {'Has Manager'}>+<Controls = {'NA'}>} If(WildMatch([Member of], '*ALL_Generic_Accounts*'),Accounts)

[xyz1]

.

[YoussefBelloum]

if Sasidhar expression works fine for you, try this on a listbox (filter):

=Aggr(Count(

{

<["Member of]={'ALL_Generic_Accounts'},Role = {'NO_PWDEXP'}>

+

<["Member of]={'ALL_Generic_Accounts'},[Claimed/Unclaimed Account]= {'Has Manager'}>

+

<["Member of]={'ALL_Generic_Accounts'},Controls= {'NA'}>

}

[Accounts]), Accounts)

[xyz1]

.