Skip to main content

Hi.

Null values are excluding in the rpeort when we use the Excludes Operation for Picklist fields.

But we have a work around to accomplish this. Most of them already know how to ge the Null data, but posting it for the new once.

Ex: In the Object for one of the Picklist field we have (Active, InActive, Churn, None) values.

Screenshot:

And if we used the Excluded operator in filetr for this field, we are not getting null records count.

For Ex, I used the filter like this, Status Excludes Inactive, Churn. In this case I am getting only Active Records count.

Screenshot:

 

So if we want to include the Null records cout we have a work around for this, which is we have to create onemore filter witht the same field and use =Null. And in Advanced Logic use OR condition.

Screenshot:

 

Thanks.

Hi @phani_kumar 

Most of these are related to how the underlying data sources work with picklist querying. Any differences you see is the differtence in behaviors of the data sources. To normalize that, what we are doing is explicitly asking if you want to include nulls or not in the filter itself. PFA a sneakpeak below and let me know if this works

 

 

Hoo Super @rakesh. Thanks for giving this feature. When we will get this enabled in all Orgs.

March is the current target Phani!

Terms & ConditionsCookie settings