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.
