I am trying to count repetitive values of a field. example there is one field " status" and the values options are "IE", IE1", IE2, IE3 etc. If m trying to count repetitive number of "IE" , its count all including IE1, IE2 and IE 3. How can i differentiate between them? for now i have done this:
status list = summary of "status field"
status list count = calc(pattern count (status list;"IE")
but this is giving me all values including "IE" string.. not only "IE string"