Payroll-Personal Payment Details Real Time Target Bank Account is Null but not "IsNull" in the field
Summary:
Content (required):
We are trying to find all the employees that have missing Bank Account Numbers or Bank Sort Codes
We are currently using Payroll - Personal Payment Details Real Time
So when we are trying to report on these fields that are showing as "Blank" they are not classed as "null" but they are also not classed as a numerical number.
So if you put in a filter of "Is Null" or is not a number nothing gets returned it negates the employees with "No data" in those fields
How can i pull the data showing the employees with "no data" within these Bank Account and Bank Sort Code fields