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

[KodandaPani_KV]

Hi,

use the aggregation type - counter for all values that are null or zero.

reference char -> condition type.

put the condition type in free char panel.

after try the result bex analyzer and RSRT.

Thanks,

Phani.

[former_member182997]

Hi  kodanda pani KV

thanks for your reply. I have tried counter. But no luck.
but counter will not  give the display of billed quantity isn't it?
only option i find is average of all the values to pick a unique vale and get it displayed in result.

Your thoughts please!

Thank you so much