7 Replies Latest reply: Jul 8, 2016 11:02 AM by Sunny Talwar RSS

    Problem in Filtering data in Set Analysis

    sumit sahu

      I have data where i have three columns:


      a | b | c


      I want to write set analysis to calculate avg of c when b <> "text1/text2". Where (text1/text2) is just text in column b.

      Here the value i am comparing has "/", i think that is creating problem in comparison.

      I am writing set analysis as given below and its not working:



      Can anyone please help me with this, I am stuck here.