Only Function help

[ivandrago]

Hi,

Does anyone know if you can do a OR in a Only function? For example I have the following expression

=Only({$<[Type]={'Comp'}>} Name)

which will only show Names where Type = 'Comp'

I want to changed the query so it will show a Type of 'Comp' OR 'Open', I tried the the following but does not seem to work

=Only({$<[Type]={'Comp'} OR [Type]={'Open'}>} Name)

Has anyone any ideas

Thanks

[swuehl]

You can list more than one value in the element_list:

=Only({$<[Type] = {'Comp','Open'}>} Name)