I have a virtual column with this expression to show a list result:
SELECT(Trips[ID],
AND(
([Driver]=[_THISROW].[Driver]),
([Date]>=[_THISROW].[Start Date]),
([Date]<=[_THISROW].[End Date]
)))
I've used this in other apps and it works great but for some reason in this app it's not showing the entire list. The result is this:
Then I get an error in a report that I'm generating to send out that says it's not a list.
So the question is, what am I doing wrong? Where should I look for errors?
Thanks!
What is the col definition of Trips?
Since you are retrieving IDs, I would assume it needs to be NOT text, but of a List with Ref to Trips?
The Trips column def is List which the app auto detects when the expression is saved...I think..
It's working now. Frustrating, finally removed the table, reinstalled it used the same expressions and now all of the columns are showing up.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |