How to Count the records in one Field

[#1]

Hi

I have Emptype Type field in one table. Emptype is having FTC,FTE types,So how can i count in Text object.

[rahulpawarb]

Hello Satish,

You can use FieldValueCount() function. For example, =FieldValueCount('A') will return the count of values hold by Field A.

Or else, if you would like to count employees based on FTC or FTE then use below given sample expressions:

//Total FTC
=Count({<Emptype={'FTC'}>}EmployeeId)
//Total FTE
=Count({<Emptype={'FTE'}>}EmployeeId)

Regards!

Rahul

[#3]

Thank You

Rahul

[rahulpawarb]

Cheers,

Rahul

[avinashelite]

if you want to count all the Emptype then count(Emptype)

if you need distinct count then count( DISTINCT Emptype)

for specific value count({<Emptype={'FTC','FTE'}>}Emptype)

[#6]

count({<[cód]={'10','114'}>}[cód])

Isso me ajudou muito!!!!!