Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be try this
=IF(fmlyGRP <> 'Condiments' and fmlyGRP <> 'Food Preps', fmlyGRP)
May be try this
=IF(fmlyGRP <> 'Condiments' and fmlyGRP <> 'Food Preps', fmlyGRP)
Or just this
If(not Match(fmlyGRP, 'Condiments', 'Food Preps'), fmlyGRP)