/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PublicSymptom
How does rounding off work for Calculated Columns in ORD ? For example, a value of 0.05 is displayed as 0.1 instead and that is incorrect.
Environment
SAP SuccessFactors Workforce Analytics
Cause
Decimal number format
Resolution
The value that will be displayed in the report will depend on the number of decimal places set in the Calculated Column Designer.
For example, if the resulting value of the calculation is 0.05, but the number of decimal places selected is only one (1), then ORD will automatically round up and display 0.1 in the report. To avoid such a result, use two (2) decimal places for example (to keep 0.05).
See Also
https://community.successfactors.com/t5/Reporting-and-Analytics/Rounding-in-Online-Report-Designer/m-p/33195/highlight/true#M175
Keywords
rounding off in ORD, online report designer rounding, decimal places in ORD , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)