cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member242633
Participant
0 Kudos
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

Accepted Solutions (0)

Answers (2)

Answers (2)

Loed
Active Contributor
0 Kudos

Hi,

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

Regards,

Loed

kohesco
Active Contributor
0 Kudos

Hi

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

Grtz

Koen