12 Replies Latest reply: Jun 7, 2016 7:39 AM by Automation - RSS

    Set analysis with variable in expression

    Automation -

      For analysis I need a result depending expression.
      The expressions has to be: 
          =avg({$} DISTINCT DailyProduction)


           =avg({1} DISTINCT DailyProduction)


      In a variable vSelect I move the character 1 or $.

      I thought that I could use the following expression:

           =avg({=$(vSelect)} DISTINCT DailyProduction)

      but unfortunately this expression results always in an error.

      Does anyone know a solution for this problem?