joker problem

[#1]

I got a problem with a count if

I have a field with 5 digit itemnumbers and want to get all that starts with 7

count(IF(itemnumber='7%%%%' ,................................................

´How do i use a joker like % or * or what is it??

[alexandros17 · Accepted solution]

count(If(wildmatch(itemnumber,'7*')>0, .....

Let me know

[senpradip007]

Try like:

Count(if(WildMatch(itemnumber, '7*')>0, itemnumber)

[mjayachandran]

You can also

=if(left(itemnumber,1) = 7, itemnumber, null())

[tresesco]

Or, using set analysis to better the performance, like:

=Count({<itemnumber={"7*"}>}intemnumber )

Note: See if you need DISTINCT or not.