Skip to Content
0

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

Apr 05, 2017 at 07:19 AM

185

avatar image
Former Member

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.

2 Answers

avatar image
Former Member Feb 12 at 09:55 AM
0

Hi,

I am getting exactly the same issue.

Did you find a resolution?

Regards,

Steve

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 12 at 02:50 PM
0

Found the solution, in case anybody is interested:

The problem was only there when the view was used from AfO. The calculated column was a DECIMAL with two decimal places and the formula was:

(Numerator/Denominator)*100

When called from AfO it seems to perform the calculation in two stages

1. Numerator / Denominator - but the result is represented in the format of the column so 123 / 4567 = 0.026932 but, because of the two decimal places, gets represented as 0.02

2. Result of step 1 * 100. In this example 0.02 * 100 = 2.00

I got around it by changing the formula to (Numerator*100)/Denominator. So there is no chance to lose the decimal places:

1. 123*100 = 12300

2. 12300 / 4567 = 2.693234 but is represented as 2.69

Share
10 |10000 characters needed characters left characters exceeded