Skip to Content
0

how to calculate aveage based on calmonth and other character in BEX

Feb 16 at 06:46 AM

25

avatar image
Former Member

I need to create new column avearge and it should calculate based on month and Adviser.how can we design in Bex.

below is the scenario

Calmonth adviser calday count Average(New column to be created)

01.2017 Engineer 01/05/2017 2 4

01.2017 Engineer 01/07/2017 4 4

01.2017 Engineer 01/08/2017 6 4

01.2017 supplier 01/02/2017 4 6

01.2017 supplier 01/05/2017 6 6

01.2017 supplier 01/06/2017 8 6

10 |10000 characters needed characters left characters exceeded
Former Member

explained in details

average.png (14.9 kB)
0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Loed Despuig Feb 23 at 06:15 AM
0

In the AGGREGATION tab of your formula, choose AVERAGE in EXCEPTION AGGREGATION with reference characteristic to CALMONTH and ADVISER.

Regards,

Loed

Share
10 |10000 characters needed characters left characters exceeded