SAP Knowledge Base Article - Public

3692289 - Filtering with multiple advanced filters in a report does not change the data.

Symptom

Using multiple advanced filters in report does not change the data in the report view. 

Environment

  • SAP Cloud for Customer
  • SAP Business ByDesign

Reproducing the Issue

  1. Open the report you want to filter the data in.
  2. Click on a value help for one of your selection fields.
  3. In the Advanced tab set two filters such as "is greater than or equal to" and "is less than or equal to".
  4. Notice the data in the report does not change.

Cause

The issue occurs because it is not possible to set two conditions, such as "is greater than or equal to" and "is less than or equal to", simultaneously in the "Advanced Filter". These conditions only work separately.

Resolution

  1. Use the "BETWEEN" operator for the field you are filtering on to filter the correct values as expected.
  2. Avoid setting two conditions, such as "is greater than or equal to" and "is less than or equal to", simultaneously in the "Advanced Filter".
  3. Test the filter functionality using the "BETWEEN" operator to ensure it meets the required criteria.

Keywords

start-date filter, advanced filter, greater than, less than, between operator, analytics, reporting issue, filter criteria, report malfunction, relative filter, , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions