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

[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

[Former Member]

explained in details

[Loed]

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

Regards,

Loed