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 :     



      (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:  




      (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 !!!