SAP Knowledge Base Article - Public

2352701 - Add Boolean fields to the field types offered in ORD / Analytics / Report-Canvas Calculated Columns


Few fields which are of "Boolean" data type are not available in the "Calculated Column page".

Users will not be able to use such fields to create calculated column.


SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Login to the Instance
  2. Navigate to Report Center
  3. Create a Canvas Report
  4. Create a calculated column
  5. You will find that the boolean fields are not showing up.

Example: Position MDF Object.
Vacant field would most likely be a boolean field


Calculated Columns currently recognize only three Data types currently ( i.e. Number, String, Date) .


We currently do not support fields of Boolean datatype in calculated column of Advanced Reporting. This is as per the current system design.

See Also

2877303 - Quick Guide to Enable People Analytics Report Story - SAP ONE Support Launchpad


Calculated Columns, Boolean fields, data type as boolean, Boolean, realms, advanced reporting, Report-Canvas, Report Canvas, Detailed Reporting , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem


SAP SuccessFactors HXM Suite all versions