3435613 - "greater than/less than" operators not showing up in a Calculated Field or resulting in incorrect results - Integration Center

When building a Calculated Field in Integration Center using conditions like greater than, less than, or greater/less than or equal to:

• Operators don’t appear in the dropdown list, or

• The results of the calculation are incorrect (e.g., 127 >= 20 returns FALSE).
  
  
  

"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

This is a known bug being addressed by the engineering team. Internal reference: INC16081821

The issue occurs because the field in the calculation logic is incorrectly associated with the “DateTimeOffset” datatype instead of a numeric type.

This misclassification causes wrong operator options showing up.

How to Confirm

1. Export the integration definition (.icd file).

2. Open it in a text editor.

3. Search for "operation": "IFTHENELSE".

4. If the associated datatype is "DateTimeOffset", this is the cause.
   
   

1. Delete the faulty calculation line (e.g., line 2 in the KBA example).

2. Recreate the logic:

   • But first, temporarily associate the calculation with an integer field (e.g., candidateId) to force correct operator mapping.

   • Then switch back to the intended Field Value selection.

3. Verify that the full set of comparison operators now appears (>, <, >=, <=).
   
   
   
   

How to Confirm

After the fix, the results of the calculation should be correct (e.g. 127 >= 20 returns TRUE).

Also, if you re-export and confirm the datatype is numeric in the .icd file.

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-INC , Integration Center , Problem