Customer has 2 values in the picklist - Yes and No.
While creating the report on the field - It shows 4 values.
Yes , No, Null and a Blank.
Reproducing the Issue
Login to Customer instance.
Create a Job requisition with a picklist field configured with values - [say Yes and No] and send for approvals.
During creation, value saved for this picklist field is say Yes.
Navigate to Reporting and run a report on the picklist field.
In the filter - Values displayed under reports for filtering: [Null, Yes] There is no "Empty" value displayed.
After that, update the field with value say "No Selection"
Values displayed under reports for filtering: [Null, Yes] There is no "Empty" value displayed
Again, update the field with value say "Yes"
Values under reports for filtering: [Null, Empty, Yes] [There is "Empty" value displayed]
The blank value corresponds to a 0 value in the database. If we never assign a value to a picklist field from the data when the job req got created, its value in the table in back end and on UI will be "null" but when we assign a value to a picklist field and move it back to "no selection", the value in the table and UI will be 0 (since the picklist id of no selection is 0). This is as per the original design.
So at any given point of time there could be both null and 0's in the backend tables for all the picklist fields and this gets reflected as "null" and blank values in the adhoc reports filter screen.
If the customer want to run a report to fetch all the job req's which have lets say picklist1 as "no selection", he needs to select both "null" and blank in the filter screen.
KBA , LOD-SF-RCM-ADM , Admin Center, RBP, Permissions and Settings , Problem