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

    Filtering with Difference

    raoul.tller

      Hi,

       

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

      diff1.png

       

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

      diff2.png

       

      Result:

      diff3.png

       

      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
          eva_lesny

          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