Bug or User Error???
I have 2 tables: People
Some people are supervisors of crews. A supervisorโs ID (EmpID) is referenced from the Crews table.
All people belong to a crew. The Crew field is a reference to the Crews table.
I would like to show the personโs supervisor through a VC that references the Crew table and returns the crewโs supervisor - [Crew].[Supervisor]
This expression returns the expected results in the expression tester but, returns no results in the view.
Iโve written the expression two different ways with the same results: [Crew].[Supervisor]
and ANY(SELECT(Crews[Supervisor],[Crew]=[_THISROW].[Crew]))
In the expression tester, the correct [Supervisor] results are returned yet the view is blank. Is this a bug or a user error?
If anyone can take a look, the app id is GroupMgmt-285473.
Is this still an open issue?
@Aleksi_Alkio This seems to have been resolved. The expected results are now being returned. Thanks Aleksi.
Glad to hear the problem has been solved.
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |