Count

[gautik92]

I have a scenario where some employees have latitude values and some dont have

I want to count the employees who have latitude values and count of employees who dont have

[tresesco · Accepted solution]

Try like:

Count({<latitude={'*'}>} Distinct Employees)      -->Employess with latitude values

Count({$- <latitude ={'*'}>} Distinct Employees)   -->Employess without latitude values

Or,

Count(Distinct Employees) - Count({<latitude={'*'}>} Distinct Employees)

Note: This works If 'no latitude values' means null.

[gautik92]

Hi tresesco,

without latitude not working

[Kushal_Chawda]

try

Count({<latitude={"=len(trim(latitude))>0"}>} Distinct Employees)      -->Employess with latitude values

Count({<latitude  ={"=len(trim(latitude))=0"}>} Distinct Employees)   -->Employess without latitude values

[tresesco]

Perhaps they are not really null. Could you attach a sample qvw ?

[gautik92]

values from database

[tresesco]

Did you try like:      Count({$- <latitude ={'*'}>} Distinct Employees)

[gautik92]

got it thanks