Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 23 at 06:15 AM

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

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded