Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey
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!!!
Eduardo
try:
count(if(Testserie=1 and len(trim(R_Z1V1))>0 ,L_Z1V1))
try:
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
count({<Testserie={1},R_Z1V1-={*}>}L_Z1V1)
other wise
use Gysbert Wassenaar suggestion.