SAP Knowledge Base Article - Public

3114209 - Some records with blank or null values are displaying as Zero (0) in Story charts and tables - People Analytics


Some records with blank values in Query Preview are showing randomly as either Null or Zero in Story widgets


SAP SuccessFactors People Analytics

Reproducing the Issue

1. Create a New Story

2. Add the affected field to the query

3. After saving query, put or add the field in a Story Cross tab or Chart widget

Result: some fields with blank values in Query preview are showing either as Null or Zero (0).


Null means there is no value at all, while blank means there is a value but field is blank so it can be treated as a zero value.  


To test if the field value is a true Null value or not, create a simple Calculated Column:

e.g. IF(ISNULL([Schema#Table#Field]), "Null", "NOTNull" )

If the result is Null, this means the record indeed has a true null value in the database, so in Story Charts/Table widgets the value will be displayed as (Null).

If the result is NOTNull, this means that although the display in Query Preview is blank, there is actually a value in the database (could be a space character), so the record is not null. Hence in Story view this could be translated as zero '0' to give it a label for display purposes.

See Also

Google search for explanation of the difference between Null and zero and blank values.


null, zero, value, story data, query designer , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To


SAP SuccessFactors HXM Core 2111