COUNT with multiple conditions

[PaoloGuerra]

Hi all,

I have a counter with a specific condition

Count({<userAccountControl={'66048'}>}userAccountControl)

But i need to add these 3 multiple conditions on the same function, but I don't know how I can do it.

If(AccountExpirationDate = '<>', AccountExpirationDate)

If(UserPrincipalName like '*direzione*' or userAccountControl like '*gfs*' or userAccountControl like 'servizi',UserPrincipalName)

If(Title = 'Dipendente' or Title like '*Esterno*' or Title like '*Consulent*',Title)

Can we help me please?

Thanks

[Channa]

if(match (name , '*dbd*') or match(name,'*bss*') or match(name,'xy*') , username)

[PaoloGuerra]

Thanks @Channa , I try with a condition but not work.

Count({<userAccountControl={'66048'}>}userAccountControl if(UserPrincipalName, '*direzione*')) 

[Channa]

Count({<userAccountControl={'66048'}>}userAccountControl if(UserPrincipalName, '*direzione*')) 

if (userAccountControl='66048' or match(UserPrincipalName,'*direzione*'),count(userAccountControl ))

[Channa]

is this condition possible??

If(AccountExpirationDate = '<>', AccountExpirationDate)

[PaoloGuerra]

Hi @Channa 

This condition is possibile ....

if (userAccountControl='66048' or match(UserPrincipalName,'*direzione*'),count(userAccountControl ))

but the result is

I have just delete this condition because is not necessary

If(AccountExpirationDate = '<>', AccountExpirationDate)

I need count all : 

userAccountControl='66048'

but insert conditions:

UserPrincipalName like '*direzione*' or userAccountControl like '*gfs*' or userAccountControl like 'servizi'

+ (not or)

Title = 'Dipendente' or Title like '*Esterno*' or Title like '*Consulent*

  Thank you

[Channa]

ok 

this case you need to use match

if(match(UserPrincipalName ,'*direzione*') or match(userAccountControl ,'*gfs*'),count(userAccountControl ))

try like this

[PaoloGuerra]

Unfortunately it doesn't work.

This is a print screen of the real situation.

[Channa]

it is working u extracting if match...it is matching direzon

[PaoloGuerra]

With this code doesn't work

if(match(UserPrincipalName ,'*direzione*') or match (userAccountControl ,'66048'),count(userAccountControl))

But my goal is:

Count all record of the table

where userAccountControl = 66048

if

UserPrincipalName like '*direzione*' or UserPrincipalName like '*gfs*' or UserPrincipalName like 'servizi'

and if

Title = 'Dipendente' or Title like '*Esterno*' or Title like '*Consulent*'