7 Replies Latest reply: Apr 26, 2017 12:00 AM by Anil Babu RSS

    expression in set analysis within pivot error

    m m

      i am trying to restrict a column within pivot table via set analysis.

       

      for example:

       

      Expression1=num(score -2)

       

      New Field based on setanalysis:

      sum({<num(score)-2 =  {">20"}>} score)     // this is failing. It cannot evalue my Expression 1 formula within set analysis.