0 Replies Latest reply: May 22, 2013 8:44 AM by li123456 RSS

    Aggr() problem

      Hi, just a simple question about the aggr() function.

       

           I try to create an aggregation of the following expression :     

       

      sum

      (RAMA_COUNT)/count(distinct {<TYPE={RAMA}>} Hour)/[Nombre de postes]

       

      which calculates the number of type <RAMA> every hour per operator in a month(as dimension in a graphe). It works well and draws the line.

       

      However, when I want to calculate the max and the min of this expression, I have to create an aggregation like:  

       

      aggr

       

      (sum(RAMA_COUNT)/count(distinct {<TYPE_HIS={RAMA}>} Hour)/[Nombre de postes],Month)

       

       

      and this gives different results, and I can't calculate the right min and max.....

       

       

      Could anyone help !!!

       

      THANKS SO MUCH