SAP Knowledge Base Article - Public

2818087 - Rounding off a calculated field's decimal value is not working - Integration Center

Symptom

Scenario A : On an inbound integration, you try to format the result of a calculated field to return only two decimal numbers, but after executing the integration the value is inserted without the format that was set previously. The formatting rule is not being respected.

Scenario B. For Outbound Integration with Calculated Field whose decimal value output equals '0' returns '.00' or '0' instead of expected '0.00' output using number format '#.00'

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 HCM Suite
  • Integration Center 

Reproducing the Issue

Scenario A. 

  1. Create an inbound integration
  2. Create a calculated field which will result in a decimal number
  3. Set the field format to "#.00"

    decimal_digit_1.jpg

  4. Preview shows the format correctly

    decimal_digit_2.jpg

  5. After running the integration, the format set previously is not respected

    decimal_digit_3.jpg

Scenario B

1. Under More Field Options > Put in Format > '#.00'

Result :

output (1).jpg

Cause

Scenario A : Product Limitation

Scenario B : Configuration Lacks for the Format

Resolution

Scenario A :

An inbound integration doesn't have the feature to change the format of a number that is contained within it. It's an expected behavior on Integration Center.

The format change that can be seen in the integration is just there to help in the visualization of the field's value. It doesn't effectively change the value of the field in the database.

In case you judge this functionality is important for your business processes, you can submit an enhancement request on Influence portal (KBA 2090228 - How to Submit Enhancement Requests for SAP SuccessFactors Products).

If you need to change the format of the field, you can try doing it on the EC/EP side. The KBA below can be helpful:

2475491 - How to define number format for Background Element - SuccessFactors

Scenario B:

1. Under More Field Options > Put in Format > '#0.00'

2. See Below output from and to

DECIMALKBA.jpg

See Also

SAP Successfactors Integration Center Guide

Keywords

successfactors, success, factors, integration, round, up, off, down, decimal, digit, float, double, #.00, calculated field , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , Problem

Product

SAP SuccessFactors HCM suite all versions