Skip to Content

Issue with displaying Decimal points for % Calculations while connectiong to Analysis for Office

Apr 05, 2017 at 07:19 AM


avatar image

On executing HANA Calculation view in AFO, values in a calculated column - Formula -
(A/(A+B) *100) shows without decimals.

Decimal places setting is done in HANA. And in HANA, it shows decimal places in output.
But in Analysis for office only .00 is shown instead of right decimal values

In SAP HANA Calculation view
Region Turnover
A1 10.56
A2 9.87

In Analysis for office(using above Calculation view)
Region Turnover
A1 10.00
A2 9.00

Can you please let me know what further settings are to be done in HANA inorder to avoid decimal issues.

Thanks a ton in advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers