Display value in table on multiple conditions

Loeckli — Fri, 15 Nov 2024 21:01:35 GMT

Hello Everyone

I have 2 tables that are linked via the synthetic key Name. In table 1, there are the columns "Name" and "Current".
In table 2, there are the columns "Name", "Location" and "Measured".

My goal is to create a table in the frontend with a column in which only the names are visible where the entry for Current is No and where all measurements are Yes.

Table 1)
Names only appear once

Name	Current
City	No
Trainstation	Yes
Hospital	No
School	No
Pool	Yes

Table 2)
Names appear several times

Name	Location	Measured
City	A	Yes
City	B	Yes
City	C	Yes
School	Classroom 12	No
School	Classroom 11	Yes
Hospital	Level 1	No

This is my try:

if([Current]='No' and Aggr(If(Only([Location])='Yes', Name), Name), Name)

Any tipps would be realy helpfull.

Re: Display value in table on multiple conditions

Dataintellinalytics — Mon, 18 Mar 2024 09:44:01 GMT

Please try this, it should help.

If( Current='No' and Measured ='Yes', Name,)

Re: Display value in table on multiple conditions

Loeckli — Mon, 18 Mar 2024 10:00:44 GMT

It does not work. If I programme each condition separately it works, as soon as the condition is combined by an and it does not work.

topic Re: Display value in table on multiple conditions in App Development

Display value in table on multiple conditions

Re: Display value in table on multiple conditions

Re: Display value in table on multiple conditions