SAP Knowledge Base Article - Public

3284075 - How to fetch Null or Empty value using calculated column for date field in canvas report


Is there any way to fetch Null or Empty value in report using calculated column for date field in canvas report

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
    • Analytics & Reporting (Ad Hoc, YouCalc, ORD)
      • Advanced Reporting (ODS)
      • Detailed Reporting - live data

Reproducing the Issue

  1. Login to instance and navigate to Report center
  2. Create any canvas report and try to add date field in the report
  3. Try to create a calculated column with condition where for specific date value, need Null or empty data in report
  4. Reporting tool does not allow it.


It is not possible to add empty values in date data type field as per current system design.


Please raise an enhancement request if you need this functionality to add blank value for date fields.

See Also

2090228 - How to submit enhancement ideas for SAP SuccessFactors Products


Date, Canvas, Calculated, column, Null, Empty
, KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , LOD-SF-ANA-ORD , Online Report Designer , How To


SAP SuccessFactors HXM Suite 2211