0

I have a list box that is powered by an expression to hide 1 value.

=aggr(only({<[name]-={John}>}[name]),[name])

But i want to add a second name to this. I have tried...

=aggr(only({<[name]-={John, Alan}>}[name]),[name])

And

=aggr(only({<[name]-={John}, {Alan}>}[name]),[name])
Matt
  • 14,906
  • 27
  • 99
  • 149

1 Answers1

0

Single quotes are required to indicate explicit values:

=aggr(only({<[name]-={'John', 'Alan'}>}[name]),[name])
Matt
  • 14,906
  • 27
  • 99
  • 149