I have this formula runing in table called Reports. Staff[Name] is a NAME type column. Report[Staff] is an ENMULIST and Base Type is Name
Select(Staff[StaffID],IN([Name],ANY(Select(Report[Staff],TRUE))))
If Report[Staff] = Bob
Then the result is Bob
If Report[Staff] = Bob, John, Simon
Then the result is Bob
If Report[Staff] = John, Simon
Then the result is John
The formula is in a Virtual Column of type Ref because Staff[StaffID] is the Key Column. Presumably irrelevant?
Tried Select(Staff[StaffID],IN([Name],[_ThisRow].[Staff])) but its the same result
Driving me nuts. Canโt see the issue.
Solved! Go to Solution.
This:
Select(Staff[StaffID],IN([Name],ANY(Select(Report[Staff],TRUE))))
should be:
Select(Staff[StaffID],IN([Name],Select(Report[Staff],TRUE)))
or:
Select(Staff[StaffID],IN([Name],Report[Staff]))
This:
Select(Staff[StaffID],IN([Name],ANY(Select(Report[Staff],TRUE))))
should be:
Select(Staff[StaffID],IN([Name],Select(Report[Staff],TRUE)))
or:
Select(Staff[StaffID],IN([Name],Report[Staff]))
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |