Symptom
A column in a Table report has '(null value)' as well as additional 'blank' value (could be due to a 'space' added in datasource). When trying to filter out the 'blank' value with a rule like 'Not equal to' and saving the filter, next time we edit that filter 'blank' is changed to '(null value)' causing 'blank' value to not filter out from the results.
Environment
SAP SuccessFactors HXM Suite
Resolution
As a workaround, we can use 'By My Selection' and add the required values rather than using 'By Rule'.
Keywords
By Rule, By My Selection, Null Value, Blank, Filter, Column, Table report, not equal to , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem