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
SAP SuccessFactors HXM Suite
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:
- Assume Denominator_Fields refers the variable(s) used in the affected calculated column's denominator.
- Create a condition similar to the below one to avoid the divide by zero situation:
Note:
The following message will popup as soon as a division operation is added to a calculated column.
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-ADV , Advanced Reporting (ODS) , Problem