on 03-25-2017 1:42 PM
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
Hi,
Try to play with the exception aggregation setting. This will solve your problem.
Regards,
Loed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
please check in properties, tab calculation of the used key figures, formulae,.. Maybe the result calculation is maniplated?
Grtz
Koen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.