Skip to main content
alexa_rosen
alexa_rosen
Contributor ⭐️⭐️
Aug 23, 2018 3:26 PM UTC

Ability to exclude NULL values in Report Builder filters

We are using a Gainsight report that has three different picklist fields as filters. In order to not have to manually update this report every time a picklist option changes in Salesforce, it would be more efficient to have a Gainsight Report filter functionality that can exclude NULL values (rather than having to say 'Contains *manually select all picklist values*'.

      3 replies

      erik_chase
      erik_chase
      Contributor ⭐️⭐️
      Aug 23, 2018 3:36 PM UTC
      The only workaround I've found is to create a formula field that returns true if those multi-select picklists are null, and then filter by that formula filed equal to false.  Not a great solution, and it would be a lot easier if we could simply filter for nulls.
      Translate
        sai_ram
        sai_ram
        Expert ⭐️⭐️
        Aug 28, 2018 9:40 AM UTC
        Hi Alexa, Yes, we don't show the Null check-box when you select "Contains, Includes and Excludes" in the filter.

        When you change the operator to "Equal-to" or "Not Equal-to" you see the Null checkbox. Does this works for you?
        Translate
        erik_chase
        erik_chase
        Contributor ⭐️⭐️
        Aug 28, 2018 2:50 PM UTC
        On a multi-select picklist filter, the only options are "Includes and Excludes".
        Translate
          Terms & ConditionsAccessibility statement