Avearage in Bex

[former_member553099]

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

[Loed]

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

[KodandaPani_KV]

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.