Hello - I am trying to write a formula where a certain medication and route will not show on the report. This is my formula but when I add it to the report it removes all patients that had a route of 'Oral'. I only want to not show where they had 'Morphine' and a route of 'Oral'. These are 2 separate fields on the report.
not({Command.DISPLAY_NAME} like "*morphine*") and not({Command.ROUTE_NAME} like "*oral*")