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?
If [TenantLocal] evaluates as blank, the equality test will be TRUE. If that is undesirable, confirm it’s not blank with ISNOTBLANK() first.
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?
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.
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.
AND( ISNOTBLANK([TenantLocal]),
your above expression)
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |