Is there a possibility for logical operators in a report? I can filter within a table according to the entry in the first row or use “!” in front of the search string to filter everything that does not contain the following string. 

But is there a possibility for a logical “OR” so that I only get all values back that does neither contain A or B?

Hi Ronald,

If you add a slicer to the report you can do what you are saying. You can pick multiple things in the slicer drop down by holding in the SHIFT or CTRL key. Thus, to see everything except two aspects you would pick all the items in the slicer view except those two. If you hold in the shift key it will select them all and then hold in the CTRL key to deselect the two you don't want.

Hope this helps!

Lauren Griessel

Ronald - the double pipe delimiter can act as an OR function in a filter. For instance in a cost pool filter entering internal labor||external labor will return either value (yes I know just entering labor would also work but this is only an example   ).

Get Outlook for iOS<https://aka.ms/o0ukef>

It is working well. But it is necessary to filter only on one column. If I tried to filter on next column it was ignored. The filter on next column is colored in red so it is visible there is some problem.

Thanks Matth,

it is absolutely great and works! Exactly what we were looking for