7 Replies Latest reply: Nov 15, 2017 6:28 AM by Paolo Camerini RSS

    Set Analysis multiple expressions

    Paolo Camerini

      Hello everyone,

      I'm trying to get the correct results for an expression that should:

       

      • return the average of an "x" value
      • only for the values of "x" whose average is between 5 and 10

       

      I already tried the following:

       

      • avg({$<x={'$(=avg(x))>5'},{'$(=avg(x))<=10'}>}x)
      • avg({$<x={'$(=avg(x))>5'}+{'$(=avg(x))<=10'}>}x)
      • avg({$<x={'$(=avg(x))>5'},x={'$(=avg(x))<=10'}>}x)


      Can't solve this, hopefully someone has the solution to this.

      Thank you