Skip to Content
avatar image
Former Member

Avearage in Bex

Dear all,

Month      Value

201501      100

201502      200

201503      300

201504      400

201505      200

201506      100

201507      150

201508      200

201509      300

201510      500

201511      300

201512      400

For example :needs to be calculated in bex.

Avg value calculation (201504)=(201504+201503+201502)/3

                                                 =(400+300+200)/3

                                                 =300

Like wise for all months Avg value needs to be calculated.

Regards,

Linga

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 24, 2015 at 12:31 PM

    HI,

    create the another new formula (VALUE) -> hit the aggregation tab -> aggregation type -> Average and reference char -> calmonth and save it.

    now check the results then you will get desired output.

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2015 at 02:28 AM

    Hi,

    How do you want to get the average calculation? What's the logic? For example, in April is it the average of values from January - April? Because you did not include January in your example..

    Anyway, in the CALCULATIONS tab, use the AVERAGE function there then choose the CUMULATED values in row or column..Just experiment with them..

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded