Ensuring that all the text within the Formula’ box is highlighted, select ‘Column from the task bar at the bottom of the Formula’ pane. The ‘Filter’ ‘Column Filter’ pane will appear. ‘Insert Expand the /Appliance’ folder in the Area’ tree and double click ‘Drug ‘Subject Chemical Substance plus code’. The Filter’ pane will be displayed. ‘BNF ‘New Click the magnifying glass icon to bring up the search window. Ensuring the Case’ option is not selected and the operator is changed to ‘Match ‘Contains’ search for and select the items shown below. Click followed by ‘OK’ ‘OK’ again. The Filter’ pane will now be populated with the items selected as ‘Insert below. Click ‘OK’. The Formula’ will be updated to include the filter added as below. ‘Column Tick the option for Headings’ and the name of the column to ‘Custom & Naproxen Items’ as below. Click ‘Ibuprofen ‘OK’. The columns displayed in the Columns’ pane will be updated to ‘Selected show the amended column as below. Following the process above edit the formula for the second column to ‘Items’ filter the column by Paragraph plus code’ for the BNF Paragraph ‘BNF – Anti-Inflammatory Drugs (100101). Amend the column heading to Items’ and click The results should match the example shown ‘NSAID ‘OK’. below. Click Your selected criteria should look as below: ‘OK’.
Ensuring that all the text within the ‘Column Formula’ box is highlighted, select ‘Filter’ from the task bar at the bottom of the ‘Column Formula’ pane. The ‘Insert Filter’ pane will appear. Expand the ‘Drug /Appliance’ folder in the ‘Subject Area’ tree and double click ‘BNF Chemical Substance plus code’. The ‘New Filter’ pane will be displayed. Click the magnifying glass icon to bring up the search window. Ensuring the ‘Match Case’ option is not selected and the operator is changed to ‘Contains’ search for and select the items shown below. Click ‘OK’ followed by ‘OK’ again. The ‘Insert Filter’ pane will now be populated with the items selected as below. Click ‘OK’. The ‘Column Formula’ will be updated to include the filter added as below. Tick the option for ‘Custom Headings’ and the name of the column to ‘Ibuprofen & Naproxen Items’ as below. Click ‘OK’. The columns displayed in the ‘Selected Columns’ pane will be updated to show the amended column as below. Following the process above edit the formula for the second ‘Items’ column to filter the column by ‘BNF Paragraph plus code’ for the BNF Paragraph – Anti-Inflammatory Drugs (100101). Amend the column heading to ‘NSAID Items’ and click ‘OK’. The results should match the example shown below. Click ‘OK’. Your selected criteria should look as below: