1 2 Previous Next 15 Replies Latest reply on Sep 20, 2016 6:34 AM by Kyle Boyce

    excluding null value from quick filter drop down

    Vishal D

      I have a field 'Store Name' for some reason it has one null value.

       

      [Store Name] = [null, ABC, XYZ, TYZ]

       

      How do I exclude the null when I create a quick filter and show that as drop down?

       

      I dont want to select everything but null and create a set or parameter as that will make the list of values static. Our company could buy more stores and I want the list to be dynamic and get populated from datasource.

       

      I tried 'Conditions Tab' while creating quick filter to say formula : Store Name <> null. But it doesnt work.

        1 2 Previous Next