I have a problem with empty cells. I would like to plot this expression:
count(if(Testserie=1 and R_Z1V1<>'' ,L_Z1V1))
The thing is that I don't want to count the lines without a value... I tried with <>' ' but it doesnt work.
Thank you for your help!!!
count(if(Testserie=1 and len(trim(R_Z1V1))>0 ,L_Z1V1))
Is it Empty or Null. Null is different from empty.
If it is Null then use in set analysis as
use Gysbert Wassenaar suggestion.
Retrieving data ...