Maybe you want to check the length of the field value:
and len([PO NO.: & Comments])>0)
If you could have spaces in that fields, you may want to apply an additional trim() first:
and len(trim([PO NO.: & Comments]))>0)
But I think your if-statement is somewhat incorrect (the and is not part of the if-condition), not sure, but maybe like this
sum(if(NetWorkDays(Date,ArrivalDate)<=TransitTime and len(trim([PO NO.: & Comments]))>0 , 1,0)
/ Count(DISTINCT OrderNo)
Hope this helps,
Again thanks you for your help!! I really appreciate it . I've attached my qlikview file.
The expression does not seem to work. I get a performance of 68.400%
Hope u can help.
temp3.qvw 334.5 K