2736239 - Calculated field return "0" while previewing data in the Custom CDS View app

• You're adding two fields and one of the fields comes from the association
  For example: (DatasourceA.FieldA)+(DatasourceB.FieldB) -> DatasourceB is the associated data source
  
  
• You're using aggregation in a Calculated Field and it's returning zero. 

SAP S/4HANA Cloud Public Edition

1. Go to Custom CDS Views app
2. Preview the CDS view
3. The result of calculated field is zero

Depending of the data type that you're aggregating, when the value is 0 the system identified it as "Null" and all the aggregation ended up returning "Null" as well. For example X + null is then null (0 is returned). 

For example, if the value of the DatasourceB.FieldB is "0/Null", no matter what DatasourceA.FieldA is, the calculated field value will be "0/Null"

In order to resolve this issue, there's a function called coalesce that you need to use.

coalesce(expression1, expression2)

It says that if expression1 is not null, expression1 is returned, otherwise expression2 is returned.

In these cases, you can use for example: coalesce(DatasourceA.FieldA, 0) + coalesce(DatasourceB.FieldB, 0)

SAP Help Portal | Functions for Calculated Fields

Custom CDS View, 0, calculated field, returning, calculation, zero, null , KBA , BC-SRV-APS-GKE , Generic CDS Key User Editor , Problem

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions