SAP Knowledge Base Article - Public

2349672 - Unable to sort and filter on certain Calculated Columns in Report - Canvas

Symptom

  • Unable to sort and filter on certain Calculated Columns in Report - Canvas
  • We have created a Detailed Reporting Live Data or Advanced Reporting query but when we are trying to filter the report based on calculated column, it is not giving any results
  • No data available error

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Login to the instance
  2. Go to Report Center
  3. Edit the report > Edit Query
  4. Go to Manage Filters
  5. Apply a calculated column as filter

Cause

Limited support for calculated columns of certain data types.

Resolution

Currently the following Calculated Column definitions do not support sort, filter or Runtime filter:

  • If a calculated column contains an Adhoc column of type timestamp
  • If an AGE function is involved
  • If it uses Conditional If/Then/Else statements
  • If the source is Learning or LMS domain
  • If the Calculated column is based on another calculated column.

In order to filter on fields only use Standard fields in the filter as Calculated columns are not supported.

We request you to submit an enhancement request for the feature.
2090228 - How to Submit Enhancement Requests for SAP SuccessFactors Products

 

Keywords

cannot, filter, calculated, columns, blank, results, date, operators, not, working, greyed, grayed, out , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem

Product

SAP SuccessFactors HXM Suite all versions