SAP Knowledge Base Article - Public

2086102 - How to correct a null - WFA

Symptom

  • Creating a line chart sourced from a composite query table that contains NULL values results in gaps within the line chart.  The desired outcome is to have those gaps closed.

Environment

  • Workforce Planning and Analytics

Cause

  • The gaps are caused due to the differences between a '0' value and a NULL value.  Having a NULL value (data does not exist in the database) in the query will yield gaps in the chart because there is no data returned.

Resolution

  • In the Composite Query, add 0.000000001 at the end of the Expression so that when calculated, it will have a miniscule value of '0' instead of NULL and will reflect that in the line chart and table as seen below:

Keywords

KBA , LOD-SF-WFA-WA , Workforce Anaytics , How To

Product

SAP SuccessFactors HCM Core all versions