Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please try this, it should help.
If( Current='No' and Measured ='Yes', Name,)
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.