5 Replies Latest reply on Aug 22, 2016 6:53 AM by Sabine Honer

    How to create a range from Null - 5?

    Sabine Honer

      Hi All,

       

      I hope you are doing fine.

      I need to create a filter, that uses a range.

      Issue here is, that Null values should be also included.

       

      If I have values in dimensions, I can only pick one value, but I need to select a range

      If I use values in measures, I can use a range without Nulls.

       

      I could create a helper column, where I assign -1 for Nulls.

      Is there a way to display "Null" in filter instead of -1?

       

       

      Please find below workbook ( version 9.0; as I have also 9.2 and 9.3 installed please feel free to upgrade it if needed).

       

      NullvsNumber.jpg

       

      Best regards

      Sabine