Not Equal Expression

[PreetiKaur]

Hi,

I need to add this expression NOT(Approval Lookup[Reporting Manager]=USEREMAIL()) with Select(Approval Lookup[Reporting Manager], AND([_THISROW].[GBU] = [GBU],[_THISROW].[Practice] = [Practice])). I tried once but getting an error. 

[Aurelien]

Hi @PreetiKaur 

What about this?

SELECT(Approval Lookup[Reporting Manager], 
  AND(
    [_THISROW].[GBU] = [GBU],
    [_THISROW].[Practice] = [Practice]
    USEREMAIL()<>[Reporting Manager]
  )
)

[PreetiKaur]

Hi @Aurelien 

This is to get managers list with this condition.

[Aurelien]

Did you try it ? Did you get an error message ? Did you try something else ?

Please provide some informations that allow us to help you.

[PreetiKaur]

Hi Aurelien,

Thankyou, its working now. There was an error coming out because of comma sign was missing from there. Thankyou so much