1 Reply Latest reply on Jun 22, 2018 3:55 AM by eva_lesny

    Filtering with Difference




      Currently I have created a report where we check the differences between two dates (Select date, compare with date):



      We want to add a filter on Difference so it will have an At Least filter.






      Great but where did my compare date go? Yes obviously Difference is empty for that date but we would still like to see where this difference on 3-12-2015 is based on? Any way around this?


      Attached the workbook.

        • 1. Re: Filtering with Difference

          The problem is that it will filter out all null values.

          Edit the filter and tick the "Include Null Values". Then your compare date will stay in place.

          The disadvantage of this is that rows which you want to filter out will also stay, the marks will only disappear for the not selected range.

          2 of 2 people found this helpful