6 Replies Latest reply on Jan 13, 2017 6:15 AM by Jonathan Drummey

    Last 3 weeks error

    Edward Yeldham

      Hello,

       

      I have a report as below which is filtered to only show the last 3 weeks data by day.  I would therefore only expect to have 3 rows of data showing.  As per the screenshot it is incorrectly showing more data.  The filter relating to last 3 is obviously working to a point as the days are not showing for those prior weeks but the totals are still coming through and hence it displays.

       

      The report has historically behaved in our prior financial year but I can't see why a new year would cause it to error.  The other filters on transaction date filter to the current year only and also ensure that data does not project beyond the selected date if choosing a retrospective date.

       

      Help?!