/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
A calculated column/measure using the expression COL_A / COL_B * COL_C returns 79.520 instead of the expected 80.000.
Column data types involved: COL_C DEC(15,3), COL_A DEC(8,0), COL_B DEC(8,0).
With sample values COL_A = 1, COL_B = 7000, COL_C = 560,000.000, the expression produces 79.520, while the expected arithmetic result is 80.000.
Read more...
Environment
- HANA Cloud Services HANA Cloud 1.0
- HANA on-premise 1.0 & 2.0
Product
SAP HANA 1.0, platform edition ; SAP HANA Cloud 1.0 ; SAP HANA, platform edition 2.0
Keywords
Datasphere, graphical view, calculated column, DEC(10,0), decimal precision, scale, division, multiplication, operator precedence, left-to-right, truncation, rounding, CAST DECIMAL, numeric accuracy , KBA , HAN-CLS-HC , HANA Cloud Services HANA Cloud , HAN-DB , SAP HANA Database , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)