SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

  • 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.

Cause

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

Resolution

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

See Also

2090228 - How to Submit Ideas for SAP SuccessFactors Products - SAP ONE Support Launchpad

Keywords

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

Product

SAP SuccessFactors HXM Suite 2211