Can i write an expression which will not count Blanks in database?

[#1]

I am trying to count Project ID taking customers as dimension, but it is always showing 1 count extra for every customer. In my SQL database there are blank (no entry )in ProjectID Column for few customers. It is consolidating and considering all blank as 1. Thus i am getting an extra count for every customer. Can I write an expression which can count project ID by Ignoring Blanks.

I tried writing below given Expression:

count(distinct if(not isnull(ProjectID), ProjectID))

but it is not working

[tresesco · Accepted solution]

Assuming, you are trying this expression in qv UI. Try:

=count(distinct if( Len(Trim(ProjectID))>0, ProjectID))

[#3]

thanks treseco

it worked