Bex Query Aggregation

[Former Member]

Hi Team,

I have date key figure shown as below

capture.jpg

and I created report but this date field is giving results with summing( Please check Last field).I tried Exception aggragation but not worked.Could you any one please help on Exception aggregation.

sc.png

Thanks and regards,

Uma

[cornelia_lezoch]

Hi Uma,

what is the most detailed char for your date?

did you define exception aggregation in query or in backend?

please post picture of the exception aggregation that you tried...

regards

Cornelia

[Loed]

Hi,

Can you explain it more? Why did you use a KF with DATE option? What do you want to do? Can you check the AGGREGATION tab in your CAPTURE.JPG if the option is SUMMATION? Then you may replace it with the option you wanted.

Regards,

Loed

[Former Member]

Hi team,

I tried all exception aggregaations but still I am getting data with aggregating values.Any suggestion.

Thanks and Regards,

Uma

[Former Member]

Hi team,

I tried all exception aggregaations but still I am getting data with aggregating values.Any suggestion.

Thanks and Regards,

Uma