7 Replies Latest reply: May 26, 2009 11:16 PM by Michael Solomovich RSS

    Expression with two func aggregation

    sertaz

      I need help:

      i have the expression:

       

      Avg(if(RTT<Avg(PTT)-1,RTT))

       

      this is wrong, because isn't posible have 2 functions aggregation (AVG) in the same expression,

      but i don't know is it.

      RTT is a Real Transit Time (40,35,30,32,54)

      PTT is a Planned Transit Time (41,35,31,29,40)

      I need:

      get Average of all RTT that are lesser that Average of PTT -1

       

      some one Idea?????

      Thanks in advance for help

      Sergio.