SAP Knowledge Base Article - Public

2528579 - “Calculated field” is not calculating correctly for few data - SuccessFactors Integration Center

Symptom

Your Integration Center job in the “Calculated field” is not calculating correctly for few data.

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

Environment

  • SAP SuccessFactors HXM Suite
  • Integration Center

Reproducing the Issue

Access your SuccessFactors > Admin Center > Integration Center > Select your integration and click on "Edit" > Click on the field and "Edit Calculation".

Cause

It is possible that your "Calculated field" uses entities with "One to Many relationship" between the OData entities.
In that case, the system internally pick the first value found if you don’t tell what you are trying to find.

Resolution

Steps to fix the issue:

1) "Edit Calculation" in your Calculated field.

01.png

2) Click in the button with "3 lines" and after that in "Associate Field".

02.png

3) Go to the bottom ("Field Filters") and define the values that you are trying to find.

In this example below, we selected the payGroup=='MTH' and payComponent=='PersonBasePayAmount'.

03.png

These selections will force the system to bring the values of these registers in the calculated field and it will avoid bring values of other payGroup or payComponent that you might have.

04.png

See Also

Integration Center Handbook

Keywords

  • SuccessFactors Integration Center (IC)
  • Calculated field
  • Incorrect calculation
  • Incorrect data from calculated field in the Integration Center
, KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , LOD-SF-INT-API , API & Adhoc API Framework , How To

Product

SAP SuccessFactors HCM Suite all versions