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

Dexpertio_LTDA · 02-20-2019 04:00 PM

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

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

Kirk_Masden

Thanks @Steve! I just came across this and will use isnotblank() to fix the problem.

Do you feel that this is something that is unavoidable or do you think it AppSheet should make = really mean = in such cases?

Steve

I think = should mean “is equal to”, period. I don’t agree with the current behavior. But the current behavior has been around longer than I have, so changing it will cause problems with apps that rely on that behavior. The work-arounds I’ve proposed are EQ() and NE() functions that provide the proper behavior.

Kirk_Masden

Thanks! I didn’t know about EQ() or NE(). I found a reference here:

That reference took me to

https://support.google.com/docs/answer/3093593?hl=en&ref_topic=3105518

I’ll try it out.

Fernando_Lopez1

AND( ISNOTBLANK([TenantLocal]),

your above expression)