Bug or User Error?????? I have 2 tables: Peo...

Bug or User Error???

I have 2 tables: People

  • (EmpID field is key, _ComputedName is the label) Crews

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.

0 3 330
3 REPLIES 3
Top Labels in this Space