Count using if statement

[Anonymous]

How can I count words which have the same first three characters (e.g. in SQL "abc%" )
using if statement maybe!

[#2]

Count(Distinct Left(FIELD,3))

[Anonymous · Accepted solution]

like this

if(left(Field,3)='abc',count(field))

[sunny_talwar]

Or may be this:

Count({<Field = {'abc*'}>} Field)

[Anonymous]

Hi Mohammed,

IF(Wildmatch(Field,'abc*'),Count(Field))

[sujeetsingh]

sunindia‌ has given the best performing expression.

[Anonymous]

thanks a lot it's working

[Anonymous]

you welcome

Regards!

[Anonymous]

if you find the right answer could  close the thread please

Regards.

[Anonymous]

from where i can close the threat i don't know how.

Best Regards.