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

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental

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 calculated 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

Note:
The following message will popup as soon as a division operation is added to a calculated column.

Div_Zero_msg.jpg

The message appears is irrespective of whether the aforementioned safeguard has been added or not.
The message is intended to be a gentle reminder and can be bypassed just by clicking 'Ok'

Keywords

Divide by zero
Calculated column
Have you added conditional statements to prevent 'Divide by Zero' errors?
Report Canvas
Online Report Designer
Advanced Reporting , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ODS , Advanced Reporting , Problem

Product

SAP SuccessFactors HCM Core all versions