SAP Knowledge Base Article - Public

2418519 - ORD query blank when filter removed


A query in Detailed Reporting, Advanced Reporting or Report Designer containing at least one Calculated Column gives blank results, either by default or when a certain filter is removed

The blank display comes up quickly so it is not timing out.


SAP SuccessFactors Online Report Designer

Reproducing the Issue

Open the query in question in the editor.  If data is showing, remove the filter in question.


If a calculated column divides by zero, it causes an error which will not allow any results to display.  Removing a filter gives the query access to more categories and more potential zeroes.


Check the Calculated Columns for any divisors.  For each one you find, use if-then clauses to check whether the denominator is zero before applying the division.  What happens if it is zero (e.g. returning zero as a result, using an alternate field) should be decided based on the purpose of the column.


KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem


SAP SuccessFactors Workforce Analytics 1608