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 |
---|---|
35 | |
31 | |
28 | |
23 | |
18 |