Skip to Content
Feb 26, 2021 at 04:19 PM

Formula Question

32 Views Last edit Mar 01, 2021 at 03:09 PM 2 rev

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*")