SAP Knowledge Base Article - Public

2086102 - How to correct a null - WFA


  • 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.


  • Workforce Planning and Analytics


  • 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.


  • 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:


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


SAP SuccessFactors HXM Core all versions