Calculate count number with dot

[vsap2000]

Hello Guys.

I have a field name Class_id which has value 

1

1.1

1.2.1

2

2.1

2.2

3

4

IF i do count of Class_id I will get 8, now requirement is to calculate count which has dot or period, if I count those will get answer as 4, so how can I get using set analysis or any other approach.

Thanks in advance.

vsap2000

[Kushal_Chawda]

how is the value of period?

[vsap2000]

Thanks for reply and sorry for confusion, I need to count for Class_id that has dot or period as shown below

1.1

1.2.1

2.1

2.2

so answer I should get 4.

Hope that clarifies.

-vsap2000

[Kushal_Chawda · Accepted solution]

try this expression

=count({<Class_ID={"=SubStringCount(Class_ID,'.')"}>}Class_ID)

[vsap2000]

Thanks Kush, it worked. I have other question related to this subject, if I need to get the count of Class Id which don't have . or period how I can accomplish that? So here I need to count for Class Id 

1

2

3

4

Thanks again.

- vsap2000

[Kushal_Chawda · Accepted solution]

this should work

=count({<ID={"=SubStringCount(ID,'.')=0"}>}ID)

[vsap2000]

Thanks for your help.