SAP Knowledge Base Article - Public

2210726 - Workforce Analytics query shows both zeroes and blanks

Symptom

A chart based on a Workforce Analytics query displays '0' in some cells with no results, and other such cells are blank.

Environment

SuccessFactors Workforce Analytics - Query Workspace or Report Designer

Cause

A zero is shown in a cell where there are records matching the criteria for the row and column but they do not count towards the measure for some reason.  Say a Terminations result for a certain category is zero; either there is a "movement - out" in the right area at the right time but it is not a termination (perhaps it's a transfer instead) or there is a termination but it is excluded for some reason.  The system does a calculation and determines that the answer is zero.

A blank is shown instead when there are no records matching the criteria at all.  Say the same Terminations result is blank instead; nothing even close to valid in this category has occurred.  Without records, the system does no calculation and gives no result.

Resolution

To minimise the number of zeroes as opposed to blanks, you can edit queries to make the filters as specific as possible.  In the case of Terminations, for example, you could filter redundantly on Separation Reason to ensure only specific types of terminations are considered.  This will not guarantee zeroes will be elimintated in all cases, but if their appearance is significant then it can help.

Keywords

zeros, inconsistent, null , KBA , LOD-SF-WFA , Workforce Analytics & Planning , Problem

Product

SAP SuccessFactors Workforce Analytics all versions