How should a report filter be configured if it must show loans created in the previous quarter and not have a status of New?

The correct approach for the report filter is to create two conditions: one for the Creation Date and another for the Work Status. Specifically, the filter should include loans created in the previous quarter, ensuring only those relevant loans are considered in the report. The second condition specifies that the Work Status must not be equal to New, effectively excluding any loans that fall under that status.

Combining these two conditions guarantees that the report provides an accurate representation of the loans that are both recent—within the defined time frame—and meet the status requirement. This combination leverages comparative logic to filter the dataset appropriately, resulting in a more precise output that directly fulfills the reporting requirements.

Other options do not achieve the same level of specificity or relevance to the requirements. For example, simply filtering by loan officer and status lacks the temporal aspect needed to focus on loans from the previous quarter. Filtering solely by loan ID does not account for the necessary exclusions based on status and date criteria, while excluding loans created in the last year is too broad and ignores the specific time frame of the previous quarter altogether.