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

(Dexpertio LTDA) #1

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

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

But it did not work.

Any idea?

(Steven Coile) #2

If [TenantLocal] evaluates as blank, the equality test will be TRUE. If that is undesirable, confirm it’s not blank with ISNOTBLANK() first.

(Fernando López) #3

AND( ISNOTBLANK([TenantLocal]),

your above expression)