Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Does anybody know how to do this using set analysis.
I am trying to count records where a certain field does not start with 'Q:'
I have something like this but seems not working
count({<left(Name,2)-={'Q:'}>} Id)
I don't think you can change the left hand side of a test like that. How about ...
count({<Name-={'Q:*'}>} Id)
The wildcard * should act the same way as if you did a search from a list boxes caption.
Jonathan
I don't think you can change the left hand side of a test like that. How about ...
count({<Name-={'Q:*'}>} Id)
The wildcard * should act the same way as if you did a search from a list boxes caption.
Jonathan
Hello,
Try this :
count(if( not wildmatch(Name, 'Q:*' ), Id))
or
count({< Name-= {"Q:*"} >}Id)
Amand Dupretz
jonbroughavone, it shows zero even if i changed the <> operator.
Amand Dupretz, also shows me zero and shows no dimensions