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

    Expression with two func aggregation


      I need help:

      i have the expression:




      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