3435613 - Calculated Field in Integration Center Job not working correctly - SAP SuccessFactors integration center

Integration center calculated column have a logic that didn't work accordingly.

This is the example that we will use on this KBA: 

Calculation Trace shows: 127 is greater than or equal to 20 ==> FALSE. The right value would be TRUE.

"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 Suite

• Integration Center

1. Open the Integration Center > My integrations
2. Open a existing integration or create a new one
3. Create a calculated Column
4. Select a field from starting entity with a numeric value
5. Use a If/Then/Else operation when Field Value is less than/greater than/less than or equal to/greater than or equal to
6. Check the Condition and the value is wrong

That logic built in second row (of the KBA example) of calculation is associated with datatype "DateTimeOffset" which is wrong.

To confirm the cause, go to SAVE button and Export Integration Definition and open the .icd file with a text editor. Search for "operation": "IFTHENELSE" and you will find this:

Please remove this logic and add it once again (in the KBA example, remove the line 2 and add again).

To confirm the solution, go to SAVE button and Export Integration Definition and open the .icd file with a text editor. Search for "operation": "IFTHENELSE" and you will find this:

If when you add again the line to use If/Then/Else, there are only two operators like:

This behavior is recognized because fieldValue is linked to the String datatype. To display all the operations available with Numerics, fieldValue must be associated with an integer field. Follow the procedure outlined below:

1. In the second-row calculation, associate some field from the starting entity which is of type integer (In this KBA example, candidateId).

2. Next, switch back to fieldValue. This approach will link fieldValue to the Integer datatype, consequently listing all available operations.

After rebuild the logic, the result is right:

127 is greater than or equal to 20 => TRUE

Integration Center guide - Introduction to Calculated Fields

2491521 - Integration Center - User Assistance Documentation link 

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

less than, greater than, equal to, true, false, calculated fields, calculated column, DateTimeOffset, DateTime , KBA , LOD-SF-INT , Integrations , LOD-SF-INT-INC , Integration Center , LOD-SF-INT-INC-FWK , Integration Center UI Framework , Problem