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)
