3 Replies Latest reply: Jun 6, 2013 9:14 AM by Michael Ionkin

# Avg over fractiles inside of dimensions

Hello

I have the following problem:

I want to calculate the avg inside of the dimension only for values over 10% and under 90%

So in case there are values 1-10, I wat to calculate the avg(2,....,9)

I've managed to calculate when having onla one raw (see screenshot) with the following formula:

=Avg( If((dActVal)>Fractile(Total dActVal,0.1) and (dActVal)<=Fractile(Total dActVal,0.9) ,dActVal))

unfortunately its not working with different dimentions.

(I think I have to do sth like this   aggr(dActVal,Artikelnr,Maschinenennr)  )

• ###### Re: Avg over fractiles inside of dimensions

Has nobody an idea??

• ###### Re: Avg over fractiles inside of dimensions

Avg(Aggr(If(avg(dActVal)>=Fractile(Total <Artikelnr,Maschinenennr> (dActVal),0.1) and avg(dActVal)<=Fractile(Total <Artikelnr,Maschinenennr> (dActVal),0.9),avg(dActVal)),Artikelnr,Maschinenennr))

Using this formula it shows me the correct fractiles (over 2 Dimensions <Artikelnr, Maschinennr>) but the avg is calculate over all values in Artikelnr and Maschinennr...

Im really lost