Multiple selection blocks in a selection flowchart can be combined using connectors. There are three connectors available:
|AND||Records meeting the criteria of all the input blocks are counted|
|OR||Records meeting the criteria of one of the input blocks are counted|
|NOT||Records can be excluded based on one or more criteria defined in an input block|
In order to use on or more connectors drag the desired connector block(s) onto the worksheet.
Link the selection blocks to the connector by clicking on the small circle at the bottom of the selection block and dragging the arrow, while holding the left mouse button down, to the connector. Release the mouse button when a green edge appears around the connector.
Repeat this step to link all the required input blocks to the connector(s).
Include multiple blocks using AND.
Merging multiple blocks using OR.
Exclude one or more blocks using NOT.
When using the ‘NOT’ connector you can indicate in the connector settings which block should be used as source and which block(s) should be excluded.
Double click the ‘NOT’ block in order to open its settings.