Null Values are not including in Reports when Excludes operation used for Picklist Field
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.