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.
SAP Business ByDesign
Reproducing the Issue
- Go to Business Analytics work center.
- Select Design Reports view.
- Select the Date field and fill in all the desired fileds to fetch the report.
- 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.
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.
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.
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