AnsweredAssumed Answered

Count different repeatitive values in a list

Question asked by anjani on Jul 24, 2017
Latest reply on Jul 26, 2017 by anjani

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"

Outcomes