2395704 - ORD - Filter doesn’t work for calculated columns

SAP Knowledge Base Article - Public

2395704 - ORD - Filter doesn’t work for calculated columns


In the Online Report Designer, you can build queries in Detailed Reporting or through the editor for report components. When Filtering for Calculated Columns, some columns can be greyed out, not available to filter on.

Calculated Columns do not filter.PNG


SuccessFactors Online Report Designer


This is happening for Calculated Columns that contain IF_ELSE operators.


The Solution is to create a second Calculated Column that contains the output of the previous Calculated Column. As the new Calculated Column does not contain an IF_ELSE construct, it can be filtered upon.


Online Report Designer, Calculated Column, Calculated Columns, Filter, Filtering , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem


SAP SuccessFactors Workforce Analytics all versions