Drill Down Group

[evansabres]

I have a drill down group called 'Menu Drill'

In the group, there is a field called fmlyGRP. I want to use this filed but exclude two possible values.

I attempted to use =IF(fmlyGRP <> 'Condiments' or fmlyGRP <> 'Food Preps', fmlyGRP) with the expected output that those two values would not be displayed, however, this is not functioning.

[sunny_talwar · Accepted solution]

May be try this

=IF(fmlyGRP <> 'Condiments' and fmlyGRP <> 'Food Preps', fmlyGRP)

[sunny_talwar]

Or just this

If(not Match(fmlyGRP, 'Condiments', 'Food Preps'), fmlyGRP)