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

SAP Knowledge Base Article - Public

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

Symptom

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

Environment

SuccessFactors Online Report Designer

Cause

This is happening for Calculated Columns that contain IF_ELSE operators.

Resolution

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.

Keywords

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

Product

SAP SuccessFactors Workforce Analytics all versions