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

    Avg over fractiles inside of dimensions

    Michael Ionkin



      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)  )