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.
