Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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))
I pasted that in there and it didn't work. It still shows the total rows, not the total rows that aren't blank.
Try this?
Count({< Won_Job_ID = {"*"} >} Won_Job_ID)
OR
Count({< Won_Job_ID = {
OR
Count({< Won_Job_ID = {[=Len(Trim(Won_Job_ID))<>0]} >} Won_Job_ID)
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.