How to ignore empty cells with count function

[Anonymous]

Hi, I have a column that is Won_Job_ID that is empty unless an estimate was scheduled into an actual job. I want to do a Count of the Won_Job_ID column that ignores empty cells so I can just see how many estimates were scheduled into jobs.

Any help is greatly appreciated!

[niclaz79]

Depending on whether your fields are actually empty or contains a 0 or similar, use one of these:

Count(if(not isnull(Won_Job_ID),Won_Job_ID))

or

Count(if(Won_Job_ID<>0,Won_Job_ID))

[Anonymous]

I pasted that in there and it didn't work. It still shows the total rows, not the total rows that aren't blank.

[vishsaggi]

Try this?

Count({< Won_Job_ID = {"*"}  >} Won_Job_ID)

OR

Count({< Won_Job_ID = {

}  >} Won_Job_ID)

OR

Count({< Won_Job_ID = {[=Len(Trim(Won_Job_ID))<>0]}  >} Won_Job_ID)

[niclaz79]

Try the one with 0 but replace with ' ' instead to indicate a blank.It all depends on how the data looks which we haven't seen.