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