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

[Loed]

Hi mate,

Did you try AVERAGE OF DETAILED VALUES THAT ARE NOT ZER, NULL, OR ERROR?

Is CONDITION TYPE not really included in the report?

Loed

[former_member182997]

Dear Loed,
I tried your suggestion. I am using condition type as a free characteristic in my query.
But for this billing doc EA is not working properly. instead of 20,000 it is giving 21.818

Any other ideas mate..

-aparajit