SAP Knowledge Base Article - Public

2825310 - Greater Than and Lesser Than Filter Values in a Report

Symptom

You open a report and for any given field you set the filters as Greater than and Lesser than Filters and you expect the result within that period.

Environment

 SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics work center.
  2. Select Design Reports view.
  3. Select the Date field and fill in all the desired fileds to fetch the report.
  4. You set the Date filters in two rows. In the first filter You set the date Greater than or Equal to as for example 01.10.2019. In another filter you set the date Lesser than or equal to 31.10.2019.

You expect the result to be the dates between 01.10.2019 and 31.10.2019.

But you get the results of all dates and not between 01.10.2019 and 31.10.2019.

Cause

The reason being you get all the values is that you have selected in one filter which is Greater than or Equal to 01.10.2019. This gives the results which is greater than 01.10.2019 and not limited to any end date.

The other filter filter you have given the date values Lesser than or equal to 31.10.2019, which gives all the results which is lesser than the mentioned date Lesser than or equal to 31.10.2019 and not limited to any date.

Hence it gives all the values as these are two different filters.

Resolution

In order to get the desired results for a particular period, you have to use the filter Between, that fetches you the desired results for a specific period.

Keywords

 Report Filters, Between, Greater than or Equal to, Lesser than or Equal to , KBA , report filters , lesser than or equal to , between, greater than or equal to , SRD-FIN-ANA , Analytics Content , Problem

Product

SAP BUSINESS BYDESIGN 1611 ; SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1.0 ; SAP Business ByDesign 1302 ; SAP Business ByDesign 1305 ; SAP Business ByDesign 1308 ; SAP Business ByDesign 1311 ; SAP Business ByDesign 1402 ; SAP Business ByDesign 1405 ; SAP Business ByDesign 1408 ; SAP Business ByDesign 1411 ; SAP Business ByDesign 1502 ; SAP Business ByDesign 1505 ; SAP Business ByDesign 1508 ; SAP Business ByDesign 1511 ; SAP Business ByDesign 1602 ; SAP Business ByDesign 1605 ; SAP Business ByDesign 1608 ; SAP Business ByDesign 1702 ; SAP Business ByDesign 1711 ; SAP Business ByDesign 1802 ; SAP Business ByDesign 1805 ; SAP Business ByDesign 1808 ; SAP Business ByDesign 1811 ; SAP Business ByDesign 1902 ; SAP Business ByDesign 1905 ; SAP Business ByDesign 1908 ; SAP Business ByDesign 1911 ; SAP Business ByDesign feature pack 2.0 ; SAP Business ByDesign feature pack 2.5 ; SAP Business ByDesign feature pack 2.6 ; SAP Business ByDesign feature pack 3.0 ; SAP Business ByDesign feature pack 3.5 ; SAP Business ByDesign feature pack 4.0