Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have Emptype Type field in one table. Emptype is having FTC,FTE types,So how can i count in Text object.
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
Thank You
Rahul
Cheers,
Rahul
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)
count({<[cód]={'10','114'}>}[cód])
Isso me ajudou muito!!!!!