3650003 - Numeric calculated field results in "Not a valid number" - Integration Center

When creating a numeric calculated field, it's resulting in "Not a valid number" error in Integration Center's preview:

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

Integration Center

1. Create a numeric calculated field which, for example, sums values:
   
   
   
   
2. The calculation trace shows "Invalid Number" error:
   
   
   
   
3. And this error happens in the preview:
   
   

An empty value is being returned in one of the calculation logic fields.

When an empty value is returned by any of the fields, the calculation will not work anymore.

Note: empty value is different than 0. Empty value means that there is no value at all to be returned.

For example, considering the employee from "Reproducing the Issue" section above (106037), in the Calculation Trace it is returning:

• Value 13824.14 for pay component "BASIC_AU".
• Value 700 for pay component "MEAL_AU".
• Empty value for pay component "test".

This means that employee 106037 has no pay component "test" maintained in its profile, causing the issue in the calculation.

In order to solve this, you'll have to adapt your calculated field to avoid returning empty values. You could use an "If" condition to check for empty values before performing the calculation.

integration center, calculated fields, blank, empty, null, not a valid number, calculation, invalid number, calculation trace , KBA , LOD-SF-INT-INC-FWK , Integration Center UI Framework , Problem