SAP Knowledge Base Article - Public

3078864 - Field Comparison filter doesn't work for blank records - Canvas Report


Field comparison filter is not working for blank records

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


SAP SuccessFactors HXM Suite

Reproducing the Issue

1. Create a Canvas Report

2. Use the Field Comparison filter to compare 2 fields. For example: Currency is not equal to Description

3. The report shows blank columns even they are equal:


The report will compare the data available within the fields. If the fields have no data it will not be compared and the blank columns are expected to be displayed.


Add data in the data source for at least one of the fields.


Field, Comparison, filter, blank, empty, records, canvas, reporting, report , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem


SAP SuccessFactors HXM Suite all versions