3585920 - Addition (+) and subtraction (-) formulas will return blank/null if one of the variables is blank/null in Calculated Columns in Story reports

A formula using addition (+) or subtraction (-) formulas will return blank/null if one or more records used in the formula are blank/null.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 

SAP SuccessFactors HCM Core

This is an expected behavior as the system does not recognize the blank/null values as 0.

As a workaround, you may create a calculated column for each variable field being used in the original calculation to return blanks as 0s as use the transformed version instead.

• IF(ISNULL([Column B]), 0, [Column B])

Formula Functions in Calculated Columns for Stories in People Analytics

Sum, addition, subtraction, Story, calculated column, formula, blank, null. , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To