SAP Knowledge Base Article - Public

2349672 - Calculated Columns don't work under Manage Filters


We have created a Detailed Reporting Live Data query using Online report designer but when we are trying to filter the report based on calculated column, it is not giving any results


SAP SuccessFactors Workforce Analytics

Reproducing the Issue

  1. Login to The instance
  2. Go to Analytics Online Report Desinger
  3. Open The report > Edit Query
  4. Go to Manage Filters
  5. Apply a calculated column as filter


Limited support for calculated columns of certain data types.


Currently the following Calculated Column definitions are not supported.

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

 This will be an enhancement.



cannot filter on calculated columns, blank results for calculated columns, date calculated columns, filter operators not working , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem


SAP SuccessFactors HCM Suite all versions