AnsweredAssumed Answered

What's wrong in this expression?

Question asked by SWETHA9676 on Sep 9, 2019
Latest reply on Sep 9, 2019 by Dan Fishman

What's wrong in this expression?

if (('SWOB' > 12) and ('ROP' < 16 ))then 'ROP' else NoOutput()


This expression is giving wrong output.

Please see reference images.

As per our expression it should return 'ROP' values.

We have only 20 values for ROP < 16.So, in our expression also it should return 20 values But, I am getting 771 values as output. How is it possible? We haven't that much of data. I am attaching swob(filtered values 'SWOB'>12) values also for reference purpose.