Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 31, 2017 at 12:50 PM

    Hi

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

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 01, 2017 at 04:42 AM

    Hi,

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

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded