Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HELLO,
I'm trying to get a count of a standard that contains the letters EC in there.
I have a list of standards that have data like:
EC.02.05.03
EC.02.05.03
EC.02.05.03
EM.02.05.03
LC.02.05.03
So I'm trying to count how many start with EC and everything I've tried doesn't work.
I tried the following:
IF(INDEX(STANDARD,'EC')>0
COUNT(IF(STANDARD='EC',STANDARD))
if(trim(STANDARD)='EC'
Nothing seems to work
Try this
Count({<STANDARD = {"EC*"}>}STANDARD)
Or this
Count(If(WildMatch(STANDARD, 'EC*'), STANDARD))
If( STANDARD Like 'EC*' , ...... )
or
Count( {<STANDARD={'EC*'}>} STANDARD)
Thank you for the link!