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 Online Report Designer
SAP SuccessFactors Report Center: Report - Canvas

Reproducing the Issue

  1. Login to the Instance
  2. Navigate to analytics
  3. Create a calculated column 

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.

There is feasibility to user boolean fields, in Calculated Columns, in the latest Reporting solution: People Analytics (Report Story).

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