I need to filter a slice based on the equalit...

expressions
(Dexpertio LTDA) #1

I need to filter a slice based on the equality of one of the columns with the specific value of another two column of another table, based on the user’s record. I tried the following:

AND([TenantRole] = “Residente”, [TenantLocal] = TEXT(LOOKUP(USEREMAIL(), “Tenant”, “TenantId”, “TenantLocal”)))

But it did not work.

Any idea?

Ply healp me correting my expression

(Aleksi Alkio) #2

May I ask what is the result with your formula? It’s not working in what way?