2465622 - Error rendering List Report Component - caused by divide by zero

SAP Knowledge Base Article - Public

2465622 - Error rendering List Report Component - caused by divide by zero

Symptom

Error on screen while running the report:

Error rendering list report component


Environment

REALMS
Advanced Reporting
Online Report Designer
SuccessFactors HCM

Reproducing the Issue

Preview the report under concern from the 'Report Designer' section or the menu.

Cause

Though the error message in the front end is a common, generic one, the match in the internal logs (Analytics Logs) would indicate a possible divide by zero condition.
This would be mostly be from a calculated column.

Resolution

  • Add a static/ Run-time filter to exclude 'zero' values for Affected_Calc_Column (Affected_Calc_Column not equals zero)

    or
  • A good practice while creating calcuated columns that include division, is to include a condition to avoid divide by zero:
    1. Assume Denominator_Fields refers the variable(s) used in the affected calculated column's denominator.
    2. Create a condition similar to the below one to avoid the divide by zero situation:


      Fix_calc.jpg

Keywords

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

Product

SAP SuccessFactors Workforce Analytics 1608