SAP Knowledge Base Article - Public

3037503 - Boolean Fields cannot be used for Calculated Column in Report Story

Symptom

Boolean fields are not showing in the selection for Calculated Column in Report Story

Environment

SAP SuccessFactors HXM Suite

SAP SuccessFactors People Analytics

Reproducing the Issue

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

1. Edit the Datasource of a Report Story

2. Click Create Calculated Column button      

3. On the pop up box click Add Calculated Column button 

4. From the Edit Formula box, type in the Schema/Table where the field is added (example: Position) and see the columns you may add in the calculation.

Result: Fields that are Boolean Type are not included in the selection

Cause

Product defect

Resolution

Boolean fields are not yet supported for Calculated Columns in Report Story

See Also

Creating Calculated Columns for Stories in People Analytics

Keywords

Calculated Columns, Boolean Fields, Report Story, Stories,  People Analytics, SAC , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , Problem

Product

SAP SuccessFactors HXM Core 2011