FILTER an ENUMLIST

[1minManager]

I’ve got a Select formula that looks at an ENUMLIST column [Qualification Level] and pulls out the value of that ENUMLIST -

Select([Related Bookings][Qualification Level],
AND(
IN(“WH1”,[Qualification Level]),
[Qualification Date]=[_ThisRow].[WH1]+1095
)
)

So the formula will return something like A,B,C,D,E

I want to adapt it so that the list it displays only shows B and/or C if they exist and nothing else.

I’d prefer it in one single VC rather that one column to find the list and another to abbreviate it.

The only way I can think to do it is to use 2 VCs and have the second do something like

LIST(
IF(IN(“A”,[VC]),A,""),
IF(IN(“B”,[VC]),A,"")
)

But is their a more ellegant/efficent way?

Simon@1minManager.com

[Steve]

This will tell you whether [Qualification Level] includes either B or C:

(
  COUNT([Qualification Level] - LIST("B", "C"))
  <> COUNT([Qualification Level] - LIST())
)

So you could do:

SELECT(
  [Related Bookings][Qualification Level],
  AND(
    (
      COUNT([Qualification Level] - LIST("B", "C"))
      <> COUNT([Qualification Level] - LIST())
    ),
    IN(“WH1”,[Qualification Level]),
    ([Qualification Date] = ([_THISROW].[WH1] + 1095))
  )
)