I have a SELECT expression to list volunteers available due to criteria
SELECT(Volunteer Hours[Volunteer],
AND(IN([_THISROW].[Job Experience], [Experience]),
IN([_THISROW].[Day Number App Formula], [Days from info])))
This works, but I want to add in INTERSECT to check if they are already allocated another job at this time to leave them out of the list.
SELECT(Volunteer Hours[Volunteer],
AND(IN([_THISROW].[Job Experience], [Experience]),
IN([_THISROW].[Day Number App Formula], [Days from info]),
ISBLANK(
INTERSECT(
(LIST() + [List Volunteer Text Times 15 mins]),
(LIST() + [_THISROW].[List Session Text Times 15 mins])
)))
)
When I add the INTERSECT the detail view doesnโt show when I click through to it.
Some do and they donโt have a list of volunteers, so I guess thatโs why they show.
If I untick Show for this column the detail views all show.
I have used this expression the other way round, on the table of volunteers, checking which jobs they can do and that works fine
SELECT(All Days Slice[Unique ID],
OR([_THISROW].[Volunteer]=[Volunteer],
AND(ISBLANK([Volunteer]),
CONTAINS([_THISROW].[Experience],[Job Experience]),
CONTAINS([_THISROW].[Days from info],[Day Number App Formula]),
ISBLANK(
INTERSECT(
(LIST() + [_THISROW].[List Volunteer Text Times 15 mins]),
(LIST() + [List Session Text Times 15 mins])
))
)
))
In my experience, this happens because of a bug in the expression internals. The best you can try for is a work-around.
Thatโs a shame.
Do you know a workaround I can use to compare 2 lists?
Instead of ISBLANK(INTERSECT(...))
, you might consider whether this would work for you:
ISBLANK(
[List Session Text Times 15 mins]
- [_THISROW].[List Volunteer Text Times 15 mins]
)
or this:
ISBLANK(
[_THISROW].[List Volunteer Text Times 15 mins]
- [List Session Text Times 15 mins]
)
See also:
Thanks Steve. Iโll give that a go.
User | Count |
---|---|
41 | |
27 | |
27 | |
20 | |
13 |