Skip to Content
0
Former Member
Sep 22, 2005 at 01:39 PM

Calculation of Average

23 Views

Hi all,

In a cube i have equipment & plant as characteristics, CALMONTH & CALYEAR are time characteristics & Downtime and Availability % of equipment as Key figures.

In a query i am comparing the availability of equipment over the period of three months i.e. current month, month -1, & month -2 for each equipment.

I need to calculate the average availability of all equipments over the period of three months along with the availability of each equipment. The report format is as follows:

Equipment Availability(month) Month-1 Month-2

1 98.5% 97% 98%

2 99.1% 99.0% 99.2%

Average 98.8 98 98.6

Any help would be appreciated.

Regards,

Ankit