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*'.
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.
+1Hi 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?
When you change the operator to "Equal-to" or "Not Equal-to" you see the Null checkbox. Does this works for you?
On a multi-select picklist filter, the only options are "Includes and Excludes".
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.