SAP Knowledge Base Article - Public

2824977 - Not Equal to filter does not display null records - Adhoc Reporting

Symptom

  • The filter operator "Not Equal to" does not display null records
  • "Not Equal to" filter is not working for all employees
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors HCM Suite

Reproducing the Issue

  1. Create an Adhoc report
  2. Select the fields userID and State
  3. Apply a filter on an user who does not have a State value populated (e.g. 1000971)
    preview blank state.png

  4. Now apply the filter "Not Equal to Colorado"
    filters.png

  5. The expectation is to display the user, because no state also means not in Colorado
  6. But the result is blank
    result blank.png

Resolution

It is an expected behavior of the system. You can submit an idea or enhancement request about that in our community.

A workaround is to add the OR rule "Is null" in the filter:
workaround.png

See Also

2090228 - How to submit enhancement requests for SAP SuccessFactors products

Keywords

Not Equal to filter does not display is working empty blank null records Adhoc , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Product Enhancement

Product

SAP SuccessFactors HCM Suite all versions