Skip to Content
0

Bex Query Aggregation

Mar 07, 2017 at 08:43 AM

86

avatar image

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

capture.jpg (59.3 kB)
sc.png (64.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Uma kanth Mar 07, 2017 at 09:26 AM
0

Hi team,

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

Thanks and Regards,

Uma

Share
10 |10000 characters needed characters left characters exceeded
Uma kanth Mar 07, 2017 at 09:26 AM
0

Hi team,

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

Thanks and Regards,

Uma

Share
10 |10000 characters needed characters left characters exceeded
Loed Despuig Mar 09, 2017 at 02:09 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Cornelia Lezoch Mar 09, 2017 at 01:56 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded