Count of city in text object

[Anonymous]

Hi All,

i need to get count of city which is having less than 4 headcount in a text box.

Example

city , Headcount

A, 10

B, 20

C, 2

D, 1

F,  3

In textbox i need 3 , because city c, d f headcount is less than 4

Thanks in advance

[antoniotiman]

=Count({<Headcount={"<4"}>} city)

[its_anandrjs]

Try with

=Count({<Headcount={'<4'}>} city)

[arvind_patil]

Hi Shan,

Try below one:

=Count({<Headcount={'<4'}>} Distinct city)

Thanks,

Arvind Patil

[Anonymous]

Hi Shan,

Expression for your Output:

=Count({<Headcount -= {">4"}>}City)

Regards,

Rajan

[Kushal_Chawda · Accepted solution]

In case if you have more details in your data

Count({<city={"=sum(Headcount)<4"}>} city)

[Anonymous]

Hi kushal,

Thanks worked perfectly