Skip to Content
0

%A Function is not showing the correct percentage for overall result

Mar 25, 2017 at 01:42 PM

91

avatar image
percentage-is-not-correct.png

Hi,

I have create a Bex Query Where i used %A Function.this function is working for Row wise but overall percentage is showing wrong.

For Example

Dealer Plan Desp Bill Formula1(Bill+Desp) Formula1 %A Plan

101 10 5 10 15 150

102 15 4 4 8 53

Ove Result 25 9 14 23 Showing Wrong

I have checked this property also in Bex query 'Eliminate formula collision' but still showing wrong value.

i have tried with this formula also formula1/Plan * 100

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

2 Answers

Koen Hesters Mar 31, 2017 at 12:50 PM
0

Hi

please check in properties, tab calculation of the used key figures, formulae,.. Maybe the result calculation is maniplated?

Grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded
Loed Despuig Apr 01, 2017 at 04:42 AM
0

Hi,

Try to play with the exception aggregation setting. This will solve your problem.

Regards,

Loed

Share
10 |10000 characters needed characters left characters exceeded