Exception Aggregation Not Working

[former_member182997]

Dear Experts,

I have created a report for billing document details. In the report I have finding the exception aggregation for some billing documents are not working.
Would you please suggest me how can i solve this issue?

At Cube level:

I am using exception Aggregation average with condition type
desired value  is 20,000 but it is showing 21.818 which is wrong.

At Report Level:

Can you please suggest why exception aggregation is not working  here.

Best Regards

[anshu_lilhori · Accepted solution]

I just had a close look to your data and got the problem..

See in exception aggregation you always have to choose the  reference characteristic which has unique values.

In your case you choose reference characteristic as condition type.Check ZFRP it is repeated so while taking average it is considered as 1 not 2.

Total count of unique condition type is 11 so the calculation becomes 240000/11 = 21818.18

Hope this explanation gives you an idea to get the workaround for proper result.

Regards,
AL

[former_member182997 · Accepted solution]

Superb

Thank you so much for correcting me.
So what do you think should be my approach?  Actually almost all the billing docs are getting correct billed quantity display as condition type is unique in each row.
But few documents like the one in the screenshot is having problem.

Would you like to suggest few ideas? And thank you once again...for showing me the problem.
You are too good! 

Regards,
Aparajit