Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Hi tresesco,
without latitude not working
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
Perhaps they are not really null. Could you attach a sample qvw ?
values from database
Did you try like: Count({$- <latitude ={'*'}>} Distinct Employees)
got it thanks