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.
But this solution doesn't seem to work since text1 and text2 are not columns.
text1/text2 is just some random text (text1 and text2 are not columns).
for eg. "sumit/sahu"