Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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) )
Has nobody an idea??
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
Maybe this helps: