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:

      avg({<b-={'text1/text2'}>}c)

       

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

       

      Thanks