on 02-26-2021 4:19 PM
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*")
1. See this blog for information about the right way to filter data in a command (and general command info) - don't use the Select Expert with a command.
2. In the Where clause of the query, try something like this:
not(table.DISPLAY_NAME like '%morphine%' and table.ROUTE like '%oral%')
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Christy, that worked. Did not know that about the select expert and command reports, good to know.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.